ryc
Tables (15)
Clubs (동아리)
- id (Key) — varchar — Primary key — NOT NULL
- name (Field) — varchar
- category (Field2) — enum
- description (Field3) — varchar
- thumbnail_img (Field4) — varchar
- img (Field5) — varchar
application (지원)
- id (Key) — varchar — Primary key — NOT NULL
- recruitment_id (Key2) — varchar — Foreign key → recruitment.id — NOT NULL
- applicant_email (Field) — varchar
- applicant_password (Field2) — varchar
- step_id (Key32) — varchar — Foreign key → recruitment_step.id — NOT NULL
application_form (지원서 형식)
- id (Key) — varchar — Primary key — NOT NULL
- recruitment_id (Key2) — varchar — Foreign key → recruitment.id — NOT NULL
- form (Field) — JSON
- Field2
application_response (Untitled)
- id (Key3) — Primary key — NOT NULL
- application_id (Key) — varchar — Foreign key → application.id — NOT NULL
- recruitment_id (Key2) — varchar — Foreign key → application.recruitment_id — NOT NULL
- response (Field) — JSON
comment (코멘트)
- Key2 — Primary key — NOT NULL
- application_id (Key) — varchar — Foreign key → evaluation.application_id — NOT NULL
- step_id (Key3) — varchar — Foreign key → evaluation.step_id — NOT NULL
- comment (Field) — varchar
evaluation (평가)
- application_id (Key) — varchar — Foreign key → application.id — NOT NULL
- step_id (Key3) — varchar — Foreign key → recruitment_step.id — NOT NULL
- score (Field)
- comment (Field2)
interview (면접 테이블)
- id (Key) — varchar — Primary key — NOT NULL
- recruitment_id (Key2) — varchar — Foreign key → recruitment.id — NOT NULL
- start_time (Field)
- end_time (Field2)
interview_application (면접-지원 매핑)
- interview_id (Key) — varchar — Foreign key → interview.id — NOT NULL
- application_id (Key3) — varchar — Foreign key → application.id — NOT NULL
member (동아리원)
- club_id (Key) — varchar — Foreign key → Clubs.id — NOT NULL
- user_id (Key2) — varchar — Foreign key → user.id — NOT NULL
- role (Field) — enum
member_request (동아리 가입 요청)
- id (Key3) — Primary key — NOT NULL
- club_id (Key) — varchar — Foreign key → Clubs.id — NOT NULL
- user_id (Key2) — varchar — Foreign key → user.id — NOT NULL
- role (Field) — enum
- status (Field2) — enum
recruitment (모집공고)
- id (Key2) — varchar — Primary key — NOT NULL
- club_id (Key) — varchar — Foreign key → Clubs.id — NOT NULL
- name (Field) — varchar
- description (Field2) — JSON
- thumbnail_img (Field3) — varchar
- due_day (Field4) — DateTime
- status (Field5) — enum
- activity_duration (Field6) — varchar
recruitment_img (모집공고 이미지)
- recruitment_id (Key2) — varchar — Foreign key → recruitment.id — NOT NULL
- img_url (Field) — varchar
recruitment_step (공고 스텝)
- id (Key3) — varchar — Primary key — NOT NULL
- recruitment_id (Key2) — varchar — Foreign key → recruitment.id — NOT NULL
- step_type (Field) — enum
tag (동아리 소분류)
- id (Key2) — varchar — Primary key — NOT NULL
- club_id (Key) — varchar — Foreign key → Clubs.id — NOT NULL
- name (Field) — varchar
user (유저)
- id (Key) — varchar — Primary key — NOT NULL
- email (Field) — varchar
- password (Field2) — varchar
- Field3