Study Matching Service

Tables (7)

APPLICATION

  • application_id — NUMBER
  • user_id — NUMBER — Foreign key → USERS.user_id — NOT NULL
  • study_id — NUMBER — Foreign key → STUDY.study_id — NOT NULL
  • status — VARCHAR2(20)
  • applied_at — DATE

CATEGORY

  • category_id — NUMBER
  • category_name — VARCHAR2(50) — NOT NULL

NOTICE

  • notice_id — NUMBER
  • study_id — NUMBER — Foreign key → STUDY.study_id — NOT NULL
  • title — VARCHAR2(100) — NOT NULL
  • content — VARCHAR2(1000)
  • created_at — DATE

STUDY

  • study_id — NUMBER
  • leader_id — NUMBER — Foreign key → USERS.user_id — NOT NULL
  • category_id — NUMBER — Foreign key → CATEGORY.category_id — NOT NULL
  • title — VARCHAR2(100) — NOT NULL
  • description — VARCHAR2(1000)
  • max_member — NUMBER — NOT NULL
  • status — VARCHAR2(20)
  • created_at — DATE

STUDY_MEMBER

  • study_id — NUMBER — Foreign key → STUDY.study_id — NOT NULL
  • user_id — NUMBER — Foreign key → USERS.user_id — NOT NULL
  • role — VARCHAR2(20)
  • joined_at — DATE

STUDY_SCHEDULE

  • schedule_id — NUMBER
  • study_id — NUMBER — Foreign key → STUDY.study_id — NOT NULL
  • schedule_date — DATE — NOT NULL
  • place — VARCHAR2(100)
  • content — VARCHAR2(500)

USERS

  • user_id — NUMBER
  • name — VARCHAR2(50) — NOT NULL
  • email — VARCHAR2(100) — NOT NULL
  • password — VARCHAR2(100) — NOT NULL
  • major — VARCHAR2(100)
  • created_at — DATE