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')