ㄴ
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