따옴

테이블 (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