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