JIWOOHAK
Tables (9)
Detailed Subject (Detailed Stuject)
- stu_selected_sub (Key) — varchar(100) — Primary key — NOT NULL
- subject_name (Key2) — varchar(100) — Foreign key → Subject.subject_name — NOT NULL
- mem_userid (Key22) — varchar(100) — Foreign key → Subject.mem_userid — NOT NULL
Member
- mem_userid (Key) — varchar(100) — Primary key — NOT NULL
- mem_name (Field) — varchar(100)
- mem_birth (Field2) — varchar(100)
- mem_password (Field3) — varchar(100)
- mem_phonenum (Field4) — varchar(100)
- mem_identity (Field5) — varchar(10)
- mem_belonging (Field6) — varchar(100)
NationWide Test
- nationwide_name (Key) — varchar(100) — Primary key — NOT NULL
- stu_unq_num (Key2) — int — Foreign key → StudentsInfo.stu_unq_num — NOT NULL
- mem_userid (Key22) — varchar(100) — Foreign key → StudentsInfo.mem_userid — NOT NULL
- nationwide_score (Field)
Only Stdn
- mem_userid (Key) — varchar(100) — Foreign key → Member.mem_userid — NOT NULL
- mem_grade (Field)
Private Test
- private_name (Key) — varchar(100) — Primary key — NOT NULL
- private_date (Key2) — varchar(100) — Primary key — NOT NULL
- stu_unq_num (Key3) — int — Foreign key → StudentsInfo.stu_unq_num — NOT NULL
- mem_userid (Key22) — varchar(100) — Foreign key → StudentsInfo.mem_userid — NOT NULL
- private_score (Field) — int
StudentsInfo (Student Info)
- stu_unq_num (Key) — int — Primary key — NOT NULL
- mem_userid (Key2) — varchar(100) — Foreign key → Teacher Mid.mem_userid — NOT NULL
- stu_name (Field) — varchar(100)
- stu_start_year (Field2) — int
- stu_start_grade (Field3) — varchar(100)
- stu_selected_sub (Field4) — varchar(100)
Subject
- subject_name (Key) — varchar(100) — Primary key — NOT NULL
- mem_userid (Key2) — varchar(100) — Foreign key → only Teac.mem_userid — NOT NULL
Teacher Mid
- mem_userid (Key) — varchar(100) — Foreign key → Member.mem_userid — NOT NULL
only Teac (Only Tchr)
- mem_userid (Key) — varchar(100) — Foreign key → Member.mem_userid — NOT NULL
- mem_subject (Field)