ㄴ

Tables (11)

alarm

  • id — INT — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • icon — VARCHAR(30) — NOT NULL
  • snooze_interval — TINYINT — NOT NULL
  • snooze_cnt — TINYINT — NOT NULL
  • alarm_time — TIME — NOT NULL
  • monday — TINYINT(1) — NOT NULL
  • tuesday — TINYINT(1) — NOT NULL
  • wednesday — TINYINT(1) — NOT NULL
  • thursday — TINYINT(1) — NOT NULL
  • friday — TINYINT(1) — NOT NULL
  • saturday — TINYINT(1) — NOT NULL
  • sunday — TINYINT(1) — NOT NULL
  • is_vibrate — TINYINT(1) — NOT NULL
  • is_activated — TINYINT(1) — NOT NULL
  • deleted_at — TIMESTAMP
  • user_id — INT — NOT NULL
  • mission_id — INT
  • room_id — INT

avatar

  • id — INT — NOT NULL
  • theme — VARCHAR(20) — NOT NULL
  • phase — VARCHAR(20) — NOT NULL
  • avatar_img_link — TEXT — NOT NULL
  • price — INT — NOT NULL

fcm_token

  • id — INT — NOT NULL
  • value — VARCHAR(80) — NOT NULL
  • user_id — INT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

mission

  • id — INT — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • object — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • is_activated — TINYINT(1) — NOT NULL

notification

  • id — INT — NOT NULL
  • title — VARCHAR(20)
  • content — VARCHAR(30)
  • created_at — TIMESTAMP — NOT NULL
  • room_id — INT
  • fcm_token_id — INT

room

  • id — INT — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • intro — VARCHAR(30)
  • mission — VARCHAR(20)
  • group_icon — VARCHAR(30) — NOT NULL
  • topic — VARCHAR(100)
  • invitation_code — VARCHAR(100)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL

room_mission_log

  • id — INT — NOT NULL
  • alarm_name — VARCHAR(20) — NOT NULL
  • mission_picture_link — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • user_id — INT — NOT NULL
  • room_id — INT
  • mission_id — INT — NOT NULL
  • deleted_at — TIMESTAMP

room_user

  • id — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • room_id — INT — Foreign key → room.id
  • user_id — INT — NOT NULL

user

  • id — INT — NOT NULL
  • name — VARCHAR(10)
  • password — VARCHAR(255)
  • login_type — VARCHAR(20) — NOT NULL
  • social_id — VARCHAR(30) — NOT NULL
  • agree_push — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • is_deleted — TINYINT(1) — NOT NULL

user_avatar

  • id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • avatar_id — INT — NOT NULL

user_avatar_log

  • id — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • user_id — INT — NOT NULL
  • avatar_id — INT — NOT NULL