따옴
테이블 (7)
Follow (Untitled7)
- user_id (primary key) — int — 외래 키 → USER.user_id — NOT NULL
- follower_id (Field) — int
- following_id (Field2) — int
- created_at (Field3) — datetime
- Field4
PLACE (Untitled3)
- photo_id (primary key) — int — 기본 키 — NOT NULL
- name (Field) — varchar
- address (Field2) — varchar
- category (Field3) — varchar
- lng (Field4) — decimal
- lat (Field5) — decimal
Photo (Untitled5)
- place_id (foreign key) — int — 외래 키 → Photo_spot.place_id — NOT NULL
- id (primary key) — int — 외래 키 → Photo_spot.id — NOT NULL
- user_id (primary key2) — int — 외래 키 → USER.user_id — NOT NULL
- image_url (Field) — varchar
- tip (Field2) — text
- mood (Field3) — varchar
- time_tag (Field4) — varchar
Photo_like (Untitled6)
- user_id (primary key) — int — 외래 키 → USER.user_id — NOT NULL
- photo_id (foreign key) — int
- created_at (Field) — datetime
Photo_save (Untitled2)
- id (primary key) — int — 외래 키 → USER.user_id — NOT NULL
- user_id (foreign key) — int — NOT NULL
- photo_spot_id (Key2) — int — NOT NULL
- created_at (Field) — datetime
Photo_spot (Untitled4)
- place_id (foreign key) — int — 기본 키 — NOT NULL
- id (primary key) — int — 외래 키 → PLACE.photo_id — NOT NULL
- title (Field) — varchar
- description (Field2) — text
- composition_tag (Field3) — varchar
USER (Untitled)
- user_id (primary key) — int — 기본 키 — NOT NULL
- email (Field2) — varchar
- nickname (Field3) — varchar
- profile_image (Field4) — varchar
- created_at (Field5) — datetime