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