erd
테이블 (10)
album
- id — VARCHAR(128) — 기본 키 — NOT NULL
- title — VARCHAR(64) — NOT NULL
- introduction — VARCHAR(128)
- is_private — TINYINT — NOT NULL
- created_time — INT — NOT NULL
- updated_time — INT — NOT NULL
- deleted_time — INT
album_member
- user_id — VARCHAR(128) — 외래 키 → user.id — NOT NULL
- album_id — VARCHAR(128) — 외래 키 → album.id — NOT NULL
- auth_type — TINYINT — NOT NULL
- created_time — INT — NOT NULL
album_post
- id — VARCHAR(128) — 기본 키 — NOT NULL
- album_id — VARCHAR(128) — 외래 키 → album.id — NOT NULL
- user — ID` — NOT NULL
- title — VARCHAR(64) — NOT NULL
- content — VARCHAR(512)
- pictured_time — INT
- created_time — INT — NOT NULL
- updated_time — INT — NOT NULL
- deleted_time — INT
album_post_comment
- id — VARCHAR(128) — 기본 키 — NOT NULL
- post_id — VARCHAR(128) — 외래 키 → album_post.id — NOT NULL
- user_id — VARCHAR(12) — 외래 키 → user.id — NOT NULL
- comment — VARCHAR(256) — NOT NULL
- created_time — INT — NOT NULL
- updated_time — INT — NOT NULL
- deleted_time — INT
album_request
- id — VARCHAR(128) — 기본 키 — NOT NULL
- album_id — VARCHAR(128) — 외래 키 → album.id — NOT NULL
- send_user_id — VARCHAR(12) — 외래 키 → user.id
- receive_user_id — VARCHAR(12) — 외래 키 → user.id
- request_type — TINYINT — NOT NULL
- created_time — INT — NOT NULL
- has_accept — TINYINT
auth
- id — VARCHAR(255) — 기본 키 — NOT NULL
- social_type — INT — NOT NULL
- email — VARCHAR(64) — NOT NULL
- created_time — TIMESTAMP — NOT NULL
- updated_time — TIMESTAMP — NOT NULL
- deleted_time — TIMESTAMP
file_info
- id — VARCHAR(255) — 기본 키 — NOT NULL
- ext — VARCHAR(15) — NOT NULL
- version — INT — NOT NULL
- ref_id — VARCHAR(255) — NOT NULL
- category — INT — NOT NULL
- created_time — INT — NOT NULL
- updated_time — INT — NOT NULL
notice
- id — VARCHAR(128) — 기본 키 — NOT NULL
- title — VARCHAR(64) — NOT NULL
- content — VARCHAR(512)
user
- id — VARCHAR(12) — 기본 키 — NOT NULL
- auth_id — VARCHAR(255) — 외래 키 → auth.id — NOT NULL
- nickname — VARCHAR(6) — NOT NULL
앨범 게시글 좋아요 (album_post_like)
- ID (id) — VARCHAR(128) — 기본 키 — NOT NULL
- 게시글 ID (post_id) — VARCHAR(128)
- 유저 ID (user_id) — VARCHAR(128)
- Field