찍찍이

테이블 (5)

Album (Untitled2)

  • id — Long — 기본 키 — NOT NULL
  • albumname — varchar(15) — NOT NULL
  • cover — text — NOT NULL
  • album_num — Long — NOT NULL
  • Field

Feed (Untitled3)

  • id — Long — 기본 키 — NOT NULL
  • content (Field) — text
  • keyword1 (Field2) — varchar(10)
  • keyword2 (Field3) — varchar(10)
  • keyword3 (Field4) — varchar(10)
  • bookmark (Field5) — boolean — NOT NULL
  • Field6
  • id (id2) — Long — 외래 키 → Album.id — NOT NULL

Photo (Untitled5)

  • id (Key) — Long — 기본 키 — NOT NULL
  • photo_loc (Field) — text — NOT NULL
  • id — Long — 외래 키 → Feed.id — NOT NULL

User (Untitled)

  • id — Long — 기본 키 — NOT NULL
  • username — varchar(15) — NOT NULL
  • userid — varchar(15) — NOT NULL
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL
  • profile_image — text — NOT NULL
  • kakao_id — varchar(30) — NOT NULL
  • phone_number (Field) — varchar(11) — NOT NULL
  • Field2

user_album (Untitled4)

  • id — Long — 외래 키 → User.id — NOT NULL
  • id (id2) — Long — 외래 키 → Album.id — NOT NULL