11기_멋사_해커톤

테이블 (5)

Class (Untitled3)

  • class_id (Key) — int — 기본 키 — NOT NULL
  • school_id (Field) — FK
  • grade (Field2) — int
  • class (Field3) — int

Question (Untitled4)

  • question_id (Key) — int — 기본 키 — NOT NULL
  • video_url (Field) — varchar
  • Field2

School (Untitled2)

  • school_id (Key) — int — 기본 키 — NOT NULL
  • name (Field) — varchar(20)
  • code (Field2) — char(6)

Student (Untitled)

  • stu_id (Key) — int — 기본 키 — NOT NULL
  • name (Field1) — char(5)
  • phone (Field2) — char(11)
  • birthday (Field3) — date
  • id (Field4) — varchar(15)
  • pw (Field5) — varchar(25)

Teacher

  • teacher_id (Key) — int — 기본 키 — NOT NULL
  • name (Field1) — char(5)
  • phone (Field2) — char(11)
  • birthday (Field3) — date
  • id (Field4) — varchar(15)
  • pw (Field5) — varchar(25)