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