서경공모

테이블 (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