vngTripMap
Tables (5)
Likes
- Key (좋아요ID) — BIGINT — Primary key — NOT NULL
- Key (멤버ID) — BIGINT — Foreign key → Member.Key — NOT NULL
- Key (장소ID) — BIGINT — Foreign key → Place.Key — NOT NULL
Member
- Key (멤버ID) — BIGINT — Primary key — NOT NULL
- Field (아이디) — STRING
- Field (비밀번호) — STRING
Place
- Key (장소ID) — BIGINT — Primary key — NOT NULL
- Field (관광지명) — STRING
- Field (순위) — INT
- Field (주소) — STRING
- Field (카테고리) — STRING
- Field (검색수) — INT
Reply
- Key (의견ID) — BIGINT — Primary key — NOT NULL
- Key (멤버ID) — BIGINT — Foreign key → Member.Key — NOT NULL
- Key (장소ID) — BIGINT — Foreign key → Place.Key — NOT NULL
- Field (내용) — STRING
Route
- Key (경로ID) — BIGINT — Primary key — NOT NULL
- Key (멤버ID) — BIGINT — Foreign key → Member.Key — NOT NULL
- Key (장소ID) — BIGINT — Foreign key → Place.Key — NOT NULL