트센

테이블 (7)

friends

  • id — integer — 기본 키 — NOT NULL
  • sender_id — integer — 외래 키 — NOT NULL
  • receiver_id — integer — 외래 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • is_deleted — boolean — NOT NULL

match_results

  • id — integer — 기본 키 — NOT NULL
  • participant_id — integer — 외래 키 — NOT NULL
  • match_id — integer — 외래 키 — NOT NULL
  • score — integer — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • is_deleted — boolean — NOT NULL

matches

  • id — integer — 기본 키 — NOT NULL
  • tournament_id — integer — 외래 키 — NOT NULL
  • round — match_round — NOT NULL
  • status — match_status — NOT NULL
  • scheduled_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • is_deleted — boolean — NOT NULL

participants

  • id — integer — 기본 키 — NOT NULL
  • tournament_id — integer — 외래 키 — NOT NULL
  • user_id — integer — 외래 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • is_deleted — boolean — NOT NULL

single_matches

  • id — integer — 기본 키 — NOT NULL
  • user1_id — integer — 외래 키 — NOT NULL
  • user2_id — integer — 외래 키 — NOT NULL
  • user1_score — integer — NOT NULL
  • user2_score — integer — NOT NULL
  • scheduled_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • is_deleted — boolean — NOT NULL

tournaments

  • id — integer — 기본 키 — NOT NULL
  • organizer_id — integer — 외래 키 — NOT NULL
  • title — varchar(255) — NOT NULL
  • start_datetime — timestamp — NOT NULL
  • end_datetime — timestamp — NOT NULL
  • status — tournament_status — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • is_deleted — boolean — NOT NULL

users

  • id (Key) — integer — 기본 키 — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • password — varchar(500) — NOT NULL
  • email — varchar(255) — NOT NULL
  • profile_image — varchar(500)
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • is_deleted — boolean — NOT NULL