DBP

Tables (4)

ALBUM (앨범)

  • PK (ALBUM_ID) — int — Primary key — NOT NULL
  • FK (USER_ID) — int — Foreign key → USER.PK — NOT NULL
  • , (TItle) — String
  • . (description) — Text
  • . (Background_image) — String
  • ORM (Photos) — NULL

Album_user (앨범유저)

  • FK (USER_ID) — int — Foreign key → USER.PK — NOT NULL
  • FK (ALBUM_ID) — int — Foreign key → ALBUM.PK — NOT NULL

Phto (사진)

  • PK (ID) — int — Primary key — NOT NULL
  • FK (ALBUM_ID) — int — Foreign key → ALBUM.PK — NOT NULL
  • FK (USER_ID) — int — Foreign key → ALBUM.FK — NOT NULL
  • . (Title) — String
  • . (diary) — text
  • . (image_file) — String

USER (유저)

  • PK (USER_ID) — int — Primary key — NOT NULL
  • . (Username) — String
  • . (Password) — String
  • ORM (Albums) — NULL
  • ORM (shared_albums) — NULL