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)