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