서경공모
테이블 (8)
chat_room
- id — BIGINT
- team_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
competition
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- category — VARCHAR(255) — NOT NULL
- host — VARCHAR(255) — NOT NULL
- organizer — VARCHAR(255) — NOT NULL
- field — TEXT — NOT NULL
- apply_method — VARCHAR(255) — NOT NULL
- apply_start — DATETIME — NOT NULL
- apply_end — DATETIME — NOT NULL
- qualification — VARCHAR(255) — NOT NULL
- award_first — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
recruit_apply
- id — BIGINT
- recruit_post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- status — ENUM('APPLIED','ACCEPTED','REJECTED') — NOT NULL
- created_at — TIMESTAMP
recruit_post
- id — BIGINT
- competition_id — BIGINT — NOT NULL
- writer_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('OPEN','CLOSED') — NOT NULL
- created_at — TIMESTAMP
team
- id — BIGINT
- competition_id — BIGINT — NOT NULL
- create_type — ENUM('RANDOM','DIRECT') — NOT NULL
- status — ENUM('FORMING','COMPLETE') — NOT NULL
- created_at — TIMESTAMP
team_member
- id — BIGINT
- role — ENUM('LEADER','MEMBER') — NOT NULL
- joined_at — TIMESTAMP
user_competition_apply
- id — BIGINT
- user_id — BIGINT — NOT NULL
- competition_id — BIGINT — NOT NULL
- type — ENUM('RANDOM','DIRECT') — NOT NULL
- status — ENUM('APPLIED','MATCHED','CANCEL') — NOT NULL
- created_at — TIMESTAMP
users
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(200) — NOT NULL
- phone — VARCHAR(50) — NOT NULL
- gender — ENUM('MALE','FEMALE') — NOT NULL
- birth — DATE — NOT NULL
- rank — ENUM('SEED','FLOWER','TREE') — NOT NULL
- point — INT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP