k-study
Tables (5)
Calendar (Untitled4)
- cal_id (Key) — Primary key — NOT NULL
- group_id (Key2) — Foreign key → StudyGroup.group_id — NOT NULL
Lecture (Untitled)
- lecture_id (Key) — Primary key — NOT NULL
- lecture_name (Field)
- teacher (Field2)
- start_date (Field3)
- end_date (Field4)
- study_cnt (Field5)
Schedule (Untitled5)
- cal_id (Key) — Foreign key → Calendar.cal_id — NOT NULL
- group_id (Key2) — Foreign key → Calendar.group_id — NOT NULL
- date (Field)
- content (Field2)
StudyGroup (Untitled3)
- group_id (Key) — Primary key — NOT NULL
- group_name (Field)
- school (Field2)
- short_discript (Field3)
- long_discript (Field4)
- max_users (Field5)
- current_users (Field6)
Users (Untitled2)
- user_id (Key) — Primary key — NOT NULL
- keyword1 (Field)
- keyword2 (Field2)
- keyword3 (Field3)