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