coop 꼬꼬댁 닭장

테이블 (10)

Comment (댓글)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • post_id (Key2) — bigint — 외래 키 → Post.id — NOT NULL
  • id (Key3) — bigint — 외래 키 → Member.id — NOT NULL — 유저 식별자
  • content (Field2) — NOT NULL
  • created_at (Field) — NOT NULL
  • updated_at (Field3) — NOT NULL

Game (게임)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • max_player_count (Field3) — tinyint
  • name (Field) — varchar — NOT NULL

History (게임 기록)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • room_id (Key2) — bigint — 외래 키 → Room.id — NOT NULL
  • created_at (Field) — timestamp — NOT NULL
  • updated_at (Field3) — timestamp — NOT NULL
  • is_completed (Field2) — bool — NOT NULL

Member (사용자)

  • id (Key) — bigint — 기본 키 — NOT NULL — 유저 식별자
  • email (Field) — varchar — NOT NULL
  • nickname (Field2) — varchar — NOT NULL
  • password (Field3) — varchar — NOT NULL
  • created_at (Field4) — timestamp — NOT NULL
  • updated_at (Field5) — timestamp — NOT NULL
  • Field6 — double — NOT NULL

Notification (알림)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • related_id (Field) — bigint
  • target (Field2) — enum — NOT NULL
  • from_member_id (Key2) — bigint — 외래 키 → Member.id — 유저 식별자
  • content (Field3) — varchar — NOT NULL

Notification_Recipient (알림 수신자)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • notification_id (Key2) — bigint — 외래 키 → Notification.id — NOT NULL
  • is_read (Field) — bool
  • to_member_id (Key3) — bigint — 외래 키 → Member.id — NOT NULL — 유저 식별자
  • created_at (Field2) — timestamp — NOT NULL
  • updated_at (Field3) — timestamp — NOT NULL

Player (게임 참가 인원)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • game_history_id (Key2) — bigint — 외래 키 → History.id — NOT NULL
  • member_id (Key3) — bigint — 외래 키 → Member.id — NOT NULL — 유저 식별자

Post (게시물)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → Member.id — NOT NULL — 유저 식별자
  • title (Field) — varchar — NOT NULL — 필요없음 지워요
  • content (Field2) — varchar — NOT NULL
  • category (Field3) — enum — NOT NULL
  • created_at (Field4) — timestamp — NOT NULL
  • updated_at (Field5) — timestamp — NOT NULL

Rating (유저 평점)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • game_history_id (Key2) — bigint — 외래 키 → History.id — NOT NULL
  • from_member_id (Key3) — bigint — 외래 키 → Member.id — NOT NULL — 유저 식별자
  • to_member_id (Key4) — bigint — 외래 키 → Member.id — NOT NULL — 유저 식별자
  • score (Field) — tinyint — NOT NULL
  • reason (Field2) — varchar
  • created_at (Field3) — timestamp — NOT NULL

Room (게임 방)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • game_id (Key2) — bigint — 외래 키 → Game.id — NOT NULL
  • host_id (Key3) — bigint — 외래 키 → Member.id — NOT NULL — 유저 식별자
  • title (Field) — varchar — NOT NULL
  • difficulty (Field2) — enum(EASY, NORMAL, HARD, EXTREME) — NOT NULL
  • status (Field3) — enum(WATING, CLOSED, PLAYING, COMPLETED) — NOT NULL
  • visibility (Field7) — enum(PUBLIC, PRIVATE) — NOT NULL
  • created_at (Field4) — timestamp — NOT NULL
  • max_player_count (Field6) — tinyint — NOT NULL
  • playing_started_at (Field5) — timestamp