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)