1학기 관통

테이블 (8)

AttractionDescription (Untitled4)

  • Key (contentId2) — int — 외래 키 → AttractionInfo.Key — NOT NULL
  • Field (homepage) — String
  • Field2 (overview) — TEXT
  • Field3 (telname) — String

AttractionInfo (Untitled3)

  • Key (contentId) — int — 기본 키 — NOT NULL
  • Field (contentTypeId) — int
  • Field (title) — String
  • Field2 (addr1) — String
  • Field3 (addr2) — String
  • Field (zipcode) — String
  • Field (tel) — String
  • Field2 (firstImage) — String
  • Field3 (firstImage2) — String
  • Field (readcount) — int
  • Field2 (sidoCode) — int
  • Field3 (gugunCode) — int
  • Field (latitude) — double
  • Field2 (longitude) — double
  • Field3 (mlevel) — String

Heart

  • Key (id) — Long — 기본 키 — NOT NULL
  • Key (likerId) — Long — 외래 키 → User.Key — NOT NULL
  • Key (hotplaceId) — Long — 외래 키 → Hotplace.Key — NOT NULL

Hotplace

  • Key (id) — Long — 기본 키 — NOT NULL
  • Field (img) — TEXT
  • Field2 (name) — String
  • Field (contentTypeId) — int
  • Field2 (description) — TEXT
  • Field (createdAt) — LocalDateTime
  • Field (updatedAt) — LocalDateTime
  • Key (userId) — Long — 외래 키 → User.Key — NOT NULL
  • Key (sidoCode) — int — 외래 키 → Sido.Key — NOT NULL

Sido

  • Key (sidoCode) — int — 기본 키 — NOT NULL
  • Field (sidoName) — String

TripOrder (Untitled2)

  • Key (id) — Long — 기본 키 — NOT NULL
  • Key (tripPlanId) — Long — 외래 키 → TripPlan.Key — NOT NULL
  • Field (order) — int
  • Key (contentId) — int — 외래 키 → AttractionInfo.Key — NOT NULL
  • Field (latitude) — double
  • (longitude) — double

TripPlan (Untitled)

  • Key (id) — Long — 기본 키 — NOT NULL
  • Key (userId) — Long — 외래 키 → User.Key — NOT NULL
  • Field (name) — String
  • Field (startDate) — LocalDate
  • Field (endDate) — LocalDate
  • Field (createdAt) — LocalDateTime
  • Field (updatedAt) — LocalDateTime
  • Key (sidoCode) — int — 외래 키 → Sido.Key — NOT NULL

User

  • Key (id) — Long — 기본 키 — NOT NULL
  • Field (pw) — TEXT
  • Field (name) — String
  • Field (salt) — TEXT