nuvibe
테이블 (15)
archive_board
- id — BIGINT
- member_id — BIGINT
- name — VARCHAR(100) — NOT NULL
board_image
- id — BIGINT
- board_id — BIGINT
- image_id — BIGINT
chat_member
- id — BIGINT
- member_id — BIGINT
- tribe_chat_id — BIGINT
- joined_at — DATETIME
- Key — 외래 키 → image.Key — NOT NULL
chat_message
- id — BIGINT
- tribe_chat_id — BIGINT
- member_id — BIGINT
- image_id — BIGINT
- created_at — DATETIME
- Key — 외래 키 → image.Key — NOT NULL
emoji_reaction
- Key — 기본 키 — NOT NULL
- id — BIGINT
- image_id — BIGINT
- member_id — BIGINT
- type — VARCHAR(20)
image
- Key — 기본 키 — NOT NULL
- id — BIGINT
- member_id — BIGINT
- tag_id — BIGINT
- mission_id — BIGINT
- url — TEXT — NOT NULL
- created_at — DATETIME
- Key (Key2) — 외래 키 → emoji_reaction.Key — NOT NULL
- id (id2) — BIGINT — 외래 키 → 사용자.id — NOT NULL
member_term
- Key — 기본 키 — NOT NULL
- id — BIGINT
- member_id — BIGINT
- term_id — BIGINT
- agreed_at — DATETIME
mission
- id — BIGINT
- content — TEXT — NOT NULL
- target_date — DATE — NOT NULL
notification
- id — BIGINT
- member_id — BIGINT
- type — VARCHAR(20)
- content — TEXT
- is_read — BOOLEAN
- created_at — DATETIME
scrap
- id — BIGINT
- member_id — BIGINT
- image_id — BIGINT
- created_at — DATETIME
social_account
- id — BIGINT
- member_id — BIGINT
- provider — VARCHAR(20)
- provider_id — VARCHAR(255)
tag
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
- image_url — TEXT
terms
- Key — 기본 키 — NOT NULL
- id — BIGINT
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- version — VARCHAR(20) — NOT NULL
- is_required — BOOLEAN
tribe_chat
- id — BIGINT
- tag_id — BIGINT
- version — INT
- current_count — INT
사용자 (member)
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- status — VARCHAR(20)
- created_at — DATETIME
- updated_at — DATETIME
- Field