Styjun

Speeding up thousands of string parses

Isn't "Dave's protocol" good if only the database, and not the code, is leaked?

What/Where usage English vs Japanese

Was Wolfgang Unzicker the last Amateur GM?

Are "confidant" and "confident" homophones?

What is meaning of 4 letter abbreviations in Roman names like Titus Flavius T. f. T. n. Sabinus?

How to travel between two stationary worlds in the least amount of time? (time dilation)

How can I define a very large matrix efficiently?

How did שְׁלֹמֹה (shlomo) become Solomon?

Why did moving the mouse cursor cause Windows 95 to run more quickly?

Has there ever been a cold war other than between the U.S. and the U.S.S.R.?

What are the differences of checking a self-signed certificate vs ignore it?

Do intermediate subdomains need to exist?

What units are kpts?

What is the fundamental difference between catching whales and hunting other animals?

List comprehensions in Mathematica?

Motorcyle Chain needs to be cleaned every time you lube it?

Can a Time Lord survive with just one heart?

PhD: When to quit and move on?

Does Evolution Sage proliferate Blast Zone when played?

How can solar sailed ships be protected from space debris?

Could you sell yourself into slavery in the USA?

How to deal with a Murder Hobo Paladin?

Has chattel slavery ever been used as a criminal punishment in the USA since the passage of the Thirteenth Amendment?

How to add three tables in the models, Users, Student and Faculty with one column so that i can retrieve data from all three tables with one colums

Django foreign key access in save() functionWhat is wrong with my models.py?Create a new model which have all fields of currently existing modelhow to automatically add default columns to all django model tables'NoneType' object is not subscriptable in using django smart selectsHow to retrieve data from extended user modelHow to define Mode with generic ForeignKey in Djangof string interpolation syntax error python3.6Load All Data in Table from Django Models run queries from itDirect assignment to the forward side of a many-to-many set is prohibited. Use particular.set() instead

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I want it to be such that, I need the username and password to access the account, then that username gets saved as primary key in the Users table, and that username is also in Student and Faculty table, and i can access all the three table from that.
I keep using Foreign key and stuff but nothing is helping, thank you

I've tried making an abstract user, using foreign key in Users table model, , models.ManytoManyField

**

class CustomUser(AbstractUser):
 username = models.IntegerField(primary_key=True, unique=True, default=None)
 student = models.ForeignKey(StudentUser, on_delete=models.CASCADE, default=0000)
 faculty = models.ForeignKey(FacultyUser, on_delete=models.CASCADE, default=0000)
 first_name = models.CharField(max_length = 200)
 last_name = models.CharField(max_length = 200)
 email = models.EmailField()
class FacultyUser(models.Model):
 ROLE_CHOICES = (
 ('STD', 'student'),
 ('TCH', 'teacher'),
 ('CDR', 'coordinator'),
 ('HOD', 'HOD'),
 )
 f_code = models.IntegerField(unique=True, primary_key=True, default=None)
 role = models.CharField(choices=ROLE_CHOICES, max_length=3)

class StudentUser(models.Model):
 DEPARTMENT_CHOICES = (
 ('CSE', 'Computer Science Engineering'),
 ('EC', 'Electrical Engineering'),
 ('ME', 'Mechanical Engineering'),
 ('CE', 'Civil Engineering'),
 ('EX', 'Electronics Engineering'),
 ('FT', 'Fire Technology'),
 )
 SEMESTER_CHOICES = (
 ('1', 'First'),
 ('2', 'Second'),
 ('3', 'Third'),
 ('4', 'Fourth'),
 ('5', 'Fifth'),
 ('6', 'Sixth'),
 ('7', 'Seventh'),
 ('8', 'Eighth'),
 )
 GENDER_CHOICES = (
 ('M', 'Male'),
 ('F', 'Female'),
 )
 SECTION_CHOICES = (
 ('1', '1'),
 ('2', '2'),
 ('3', '3'),
 )
 department = models.CharField(choices=DEPARTMENT_CHOICES, max_length=3)
 dep_section = models.IntegerField(choices=SEMESTER_CHOICES)
 sem = models.IntegerField(choices=SEMESTER_CHOICES)
 gender = models.CharField(max_length=1, choices=GENDER_CHOICES)
 s_code = models.IntegerField(unique=True, primary_key=True, default=None)

**

django-models

share|improve this question

asked Mar 25 at 19:12

vaibhav singhvaibhav singh

111 bronze badge

add a comment | 

0

I want it to be such that, I need the username and password to access the account, then that username gets saved as primary key in the Users table, and that username is also in Student and Faculty table, and i can access all the three table from that.
I keep using Foreign key and stuff but nothing is helping, thank you

I've tried making an abstract user, using foreign key in Users table model, , models.ManytoManyField

**

class CustomUser(AbstractUser):
 username = models.IntegerField(primary_key=True, unique=True, default=None)
 student = models.ForeignKey(StudentUser, on_delete=models.CASCADE, default=0000)
 faculty = models.ForeignKey(FacultyUser, on_delete=models.CASCADE, default=0000)
 first_name = models.CharField(max_length = 200)
 last_name = models.CharField(max_length = 200)
 email = models.EmailField()
class FacultyUser(models.Model):
 ROLE_CHOICES = (
 ('STD', 'student'),
 ('TCH', 'teacher'),
 ('CDR', 'coordinator'),
 ('HOD', 'HOD'),
 )
 f_code = models.IntegerField(unique=True, primary_key=True, default=None)
 role = models.CharField(choices=ROLE_CHOICES, max_length=3)

class StudentUser(models.Model):
 DEPARTMENT_CHOICES = (
 ('CSE', 'Computer Science Engineering'),
 ('EC', 'Electrical Engineering'),
 ('ME', 'Mechanical Engineering'),
 ('CE', 'Civil Engineering'),
 ('EX', 'Electronics Engineering'),
 ('FT', 'Fire Technology'),
 )
 SEMESTER_CHOICES = (
 ('1', 'First'),
 ('2', 'Second'),
 ('3', 'Third'),
 ('4', 'Fourth'),
 ('5', 'Fifth'),
 ('6', 'Sixth'),
 ('7', 'Seventh'),
 ('8', 'Eighth'),
 )
 GENDER_CHOICES = (
 ('M', 'Male'),
 ('F', 'Female'),
 )
 SECTION_CHOICES = (
 ('1', '1'),
 ('2', '2'),
 ('3', '3'),
 )
 department = models.CharField(choices=DEPARTMENT_CHOICES, max_length=3)
 dep_section = models.IntegerField(choices=SEMESTER_CHOICES)
 sem = models.IntegerField(choices=SEMESTER_CHOICES)
 gender = models.CharField(max_length=1, choices=GENDER_CHOICES)
 s_code = models.IntegerField(unique=True, primary_key=True, default=None)

**

django-models

share|improve this question

asked Mar 25 at 19:12

vaibhav singhvaibhav singh

111 bronze badge

add a comment | 

I want it to be such that, I need the username and password to access the account, then that username gets saved as primary key in the Users table, and that username is also in Student and Faculty table, and i can access all the three table from that.
I keep using Foreign key and stuff but nothing is helping, thank you

I've tried making an abstract user, using foreign key in Users table model, , models.ManytoManyField

**

class CustomUser(AbstractUser):
 username = models.IntegerField(primary_key=True, unique=True, default=None)
 student = models.ForeignKey(StudentUser, on_delete=models.CASCADE, default=0000)
 faculty = models.ForeignKey(FacultyUser, on_delete=models.CASCADE, default=0000)
 first_name = models.CharField(max_length = 200)
 last_name = models.CharField(max_length = 200)
 email = models.EmailField()
class FacultyUser(models.Model):
 ROLE_CHOICES = (
 ('STD', 'student'),
 ('TCH', 'teacher'),
 ('CDR', 'coordinator'),
 ('HOD', 'HOD'),
 )
 f_code = models.IntegerField(unique=True, primary_key=True, default=None)
 role = models.CharField(choices=ROLE_CHOICES, max_length=3)

class StudentUser(models.Model):
 DEPARTMENT_CHOICES = (
 ('CSE', 'Computer Science Engineering'),
 ('EC', 'Electrical Engineering'),
 ('ME', 'Mechanical Engineering'),
 ('CE', 'Civil Engineering'),
 ('EX', 'Electronics Engineering'),
 ('FT', 'Fire Technology'),
 )
 SEMESTER_CHOICES = (
 ('1', 'First'),
 ('2', 'Second'),
 ('3', 'Third'),
 ('4', 'Fourth'),
 ('5', 'Fifth'),
 ('6', 'Sixth'),
 ('7', 'Seventh'),
 ('8', 'Eighth'),
 )
 GENDER_CHOICES = (
 ('M', 'Male'),
 ('F', 'Female'),
 )
 SECTION_CHOICES = (
 ('1', '1'),
 ('2', '2'),
 ('3', '3'),
 )
 department = models.CharField(choices=DEPARTMENT_CHOICES, max_length=3)
 dep_section = models.IntegerField(choices=SEMESTER_CHOICES)
 sem = models.IntegerField(choices=SEMESTER_CHOICES)
 gender = models.CharField(max_length=1, choices=GENDER_CHOICES)
 s_code = models.IntegerField(unique=True, primary_key=True, default=None)

**

django-models

share|improve this question

asked Mar 25 at 19:12

vaibhav singhvaibhav singh

111 bronze badge

class CustomUser(AbstractUser):
 username = models.IntegerField(primary_key=True, unique=True, default=None)
 student = models.ForeignKey(StudentUser, on_delete=models.CASCADE, default=0000)
 faculty = models.ForeignKey(FacultyUser, on_delete=models.CASCADE, default=0000)
 first_name = models.CharField(max_length = 200)
 last_name = models.CharField(max_length = 200)
 email = models.EmailField()
class FacultyUser(models.Model):
 ROLE_CHOICES = (
 ('STD', 'student'),
 ('TCH', 'teacher'),
 ('CDR', 'coordinator'),
 ('HOD', 'HOD'),
 )
 f_code = models.IntegerField(unique=True, primary_key=True, default=None)
 role = models.CharField(choices=ROLE_CHOICES, max_length=3)

class StudentUser(models.Model):
 DEPARTMENT_CHOICES = (
 ('CSE', 'Computer Science Engineering'),
 ('EC', 'Electrical Engineering'),
 ('ME', 'Mechanical Engineering'),
 ('CE', 'Civil Engineering'),
 ('EX', 'Electronics Engineering'),
 ('FT', 'Fire Technology'),
 )
 SEMESTER_CHOICES = (
 ('1', 'First'),
 ('2', 'Second'),
 ('3', 'Third'),
 ('4', 'Fourth'),
 ('5', 'Fifth'),
 ('6', 'Sixth'),
 ('7', 'Seventh'),
 ('8', 'Eighth'),
 )
 GENDER_CHOICES = (
 ('M', 'Male'),
 ('F', 'Female'),
 )
 SECTION_CHOICES = (
 ('1', '1'),
 ('2', '2'),
 ('3', '3'),
 )
 department = models.CharField(choices=DEPARTMENT_CHOICES, max_length=3)
 dep_section = models.IntegerField(choices=SEMESTER_CHOICES)
 sem = models.IntegerField(choices=SEMESTER_CHOICES)
 gender = models.CharField(max_length=1, choices=GENDER_CHOICES)
 s_code = models.IntegerField(unique=True, primary_key=True, default=None)

share|improve this question

asked Mar 25 at 19:12

vaibhav singhvaibhav singh

111 bronze badge

share|improve this question

asked Mar 25 at 19:12

vaibhav singhvaibhav singh

111 bronze badge

asked Mar 25 at 19:12

vaibhav singhvaibhav singh

111 bronze badge

asked Mar 25 at 19:12

vaibhav singhvaibhav singh

111 bronze badge