일타인강
테이블 (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