일타인강

테이블 (7)

Course (CopyOfUntitled2)

  • cour_serial (_id) — int — 기본 키 — NOT NULL
  • inst_id (_id2) — int — 외래 키 → instructor.inst_id — NOT NULL
  • cour_title (Field) — varchar(30)
  • cour_description (Field2) — text

instructor (CopyOfUntitled)

  • inst_id (_id) — int — 기본 키 — NOT NULL
  • inst_name (Field) — varchar(30)
  • inst_password (Field2) — varchar(30)
  • inst_email (Field3) — varchar(30)

lecture (CopyOfCopyOfUntitled2)

  • lect_serial (_id) — int — 기본 키 — NOT NULL
  • cour_serial (_id2) — int — 외래 키 → Course.cour_serial — NOT NULL
  • inst_id (_id22) — int — 외래 키 → Course.inst_id — NOT NULL
  • lect_title (Field) — varchar(50)
  • lect_content (Field2) — text
  • lect_url (Field3) — varchar(255)

note (CopyOfCopyOfCopyOfUntitled22)

  • note_id (_id) — int — 기본 키 — NOT NULL
  • user_id (_id2) — int — 외래 키 → user.user_id — NOT NULL
  • lect_serial (_id3) — int — 외래 키 → lecture.lect_serial — NOT NULL
  • note_content (Field2) — text
  • note_date (Field3) — date

quiz (CopyOfCopyOfUntitled22)

  • quiz_serial (_id) — int — 기본 키 — NOT NULL
  • cour_serial (_id2) — int — 외래 키 → Course.cour_serial — NOT NULL
  • inst_id (_id22) — int — 외래 키 → Course.inst_id — NOT NULL
  • cour_serial (Field) — int
  • quiz_title (Field3) — varchar(30)

subtitle/timeline (CopyOfCopyOfCopyOfUntitled2)

  • sub_serial (_id) — int — 기본 키 — NOT NULL
  • timeline_serial (Key) — int — 기본 키 — NOT NULL
  • lect_serial (_id2) — int — 외래 키 → lecture.lect_serial — NOT NULL
  • cour_serial (_id22) — int — 외래 키 → lecture.cour_serial — NOT NULL
  • inst_id (_id222) — int — 외래 키 → lecture.inst_id — NOT NULL
  • sub_start_time (Field) — time
  • sub_end_time (Field2) — time
  • sub_content (Field3) — text
  • time_time (Field5) — time
  • time_description (Field6) — text

user (Untitled)

  • user_id (_id) — int — 기본 키 — NOT NULL
  • user_name (Field) — varchar(30)
  • user_password (Field2) — varchar(30)
  • user_email (Field3) — varchar(30)
  • user_enroll (Key) — varchar(255) — NOT NULL