PlayBit
Tables (6)
member (사용자)
- member_id — bigint — Primary key — NOT NULL
- member_uuid — varchar(255)
- nickname — varchar(255)
- streak — bigint
- Field
mission (미션)
- mission_id — bigint — Primary key — NOT NULL
- completed_at — datetime(6)
- completed_by_member_id — bigint
- position — bigint
- content — enum('HEALTH_1','HEALTH_2','HEALTH_3','HEALTH_4','HEALTH_5','HEALTH_6','HEALTH_7','HEALTH_8','HEALTH_9','HOBBY_1','HOBBY_2','HOBBY_3','HOBBY_4','HOBBY_5','HOBBY_6','HOBBY_7','HOBBY_8','HOBBY_9','LIFE_1','LIFE_2','LIFE_3','LIFE_4','LIFE_5','LIFE_6','LIFE_7','LIFE_8','LIFE_9','STUDY_1','STUDY_2','STUDY_3','STUDY_4','STUDY_5','STUDY_6','STUDY_7','STUDY_8','STUDY_9','WORKOUT_1','WORKOUT_2','WORKOUT_3','WORKOUT_4','WORKOUT_5','WORKOUT_6','WORKOUT_7','WORKOUT_8','WORKOUT_9')
- room_id — bigint — Foreign key → room.room_id — NOT NULL
notifcation (알림)
- notification_id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.member_id — NOT NULL
- content (Field) — varchar(512)
- created_at (Field3) — datetime(6)
- title (Field2) — varchar(512)
- is_read (Field4) — boolean
- type (Field5)
- sender_id (Field6) — bigint
player (플레이어)
- player_id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.member_id — NOT NULL
- role — enum('O','X')
- room_id — bigint — NOT NULL
push_subscription (구독 정보)
- push_subscription_id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.member_id — NOT NULL
- endpoint — varchar(512)
- p256dh — varchar(256)
- auth — varchar(256)
- created_at — datetime(6)
room (방)
- room_id — bigint — Primary key — NOT NULL
- player_id — bigint — Foreign key → player.player_id — NOT NULL
- current_turn_sabotaged — bit(1)
- is_draw — bit(1)
- current_turn_member_id — bigint
- current_turn_number — bigint
- turn_deadline — datetime(6)
- turn_started_at — datetime(6)
- winner_member_id — bigint
- entry_code — varchar(255)
- category — enum('HEALTH','HOBBY','LIFE','STUDY','WORKOUT')
- status — enum('FINISHED','PLAYING','WAITING')