jam

테이블 (10)

게임상태 (room_game_status)

  • id (Key) — bit int — 기본 키 — NOT NULL
  • room_Id (Key2) — big int — 외래 키 → 방.id — NOT NULL
  • game_talk_order (Field) — TINYINT
  • status (Field2) — varchar(10)
  • started_at (Field5) — datetime
  • created_at (Field3) — datetime
  • modified_at (Field4) — datetime

금지 단어 (forbidden_word)

  • id (Key) — big int — 기본 키 — NOT NULL
  • word (Key2) — varchar(15) — 기본 키 — NOT NULL
  • status (Field4) — varchar(15)
  • created_at (Field) — datetime
  • modified_at (Field2) — datetime
  • deleted_at (Field3) — datetime

방 (room)

  • id (Key) — big int — 기본 키 — NOT NULL
  • user_id (Key2) — big int — 외래 키 → 유저.id — NOT NULL
  • title (Field) — varchar(100)
  • password (Field2) — varchar(10)
  • limited_number_people (Field8) — int
  • game_type (Field3) — varchar(15)
  • team_type (Field4) — vqrchar(15)
  • satus (Field10) — varchar(15)
  • created_at (Field5) — datetime
  • modified_at (Field6) — datetime
  • deleted_at (Field9) — datetime

유요한 단어들 (valid_word)

  • id (Key) — big int — 기본 키 — NOT NULL
  • word (Field) — varchar(7)
  • consonant (Field8) — varchar(7)
  • description (Field2) — text
  • is_exist (Field3) — bool
  • status (Field7) — varchar(15)
  • created_at (Field4) — datetime
  • modified_at (Field5) — datetime
  • deleted_at (Field6) — datetime

유저 (user)

  • id (Key) — big int — 기본 키 — NOT NULL
  • email (Field) — vqrchar(100)
  • nickname (Field2) — varchar(15)
  • gender (Field8) — varchar(5)
  • age (Field9) — int
  • status (Field3) — varchar(15)
  • signup_path (Field4) — varchar(15)
  • created_at (Field5) — datetime
  • modified_at (Field6) — datetime
  • deleted_at (Field7) — datetime

점수 (point)

  • id (Key) — big int — 기본 키 — NOT NULL
  • user_id (Key2) — big int — 외래 키 → 유저.id — NOT NULL
  • game_point (Field) — big int

차단 (block_user)

  • id (Key) — big int — 기본 키 — NOT NULL
  • user_id (Key2) — big int — 외래 키 → 유저.id — NOT NULL
  • block_user_id (Field) — big int
  • created_at (Field2) — datetime

참가자 (participant)

  • id (Key) — big int — 기본 키 — NOT NULL
  • room_id (Key2) — big int — 외래 키 → 방.id — NOT NULL
  • user_id (Field) — big int
  • status (Field2) — varchar(10)
  • order (Field5) — TINYINT
  • created_at (Field3) — datetime
  • modified_at (Field4) — datetime

친구 (friend)

  • id (Key) — big int — 기본 키 — NOT NULL
  • user_Id (Key2) — big int — 외래 키 → 유저.id — NOT NULL
  • friend_id (Field) — big int
  • created_at (Field2) — datetime

친구요청 (request_friend)

  • id (Key) — big int — 기본 키 — NOT NULL
  • user_Id (Key2) — big int — 외래 키 → 유저.id — NOT NULL
  • friend_id (Field) — big int
  • status (Field3) — varchar(int)
  • created_at (Field2) — datetime