캡스톤_2
테이블 (8)
Admin (ADMIN)
- AdminKey (Key) — INT — 기본 키 — NOT NULL
- ID (Field) — VARCHAR
- Password (Field2) — VARCHAR
- Name (Field3) — VARCHAR
Place (PLACE)
- PlaceKey (Key) — INT — 기본 키 — NOT NULL
- PlaceName (Field) — VARCHAR
- PlaceImage (Field2) — Image
- PlaceAddress (Field3) — VARCHAR
- PlaceLike (Field5) — INT
- PlaceInfo (Field4) — VARCHAR
- TagKey (Key2) — INT — 외래 키 → Tag.TagKey — NOT NULL
- ReviewKey (Key3) — INT — 외래 키 → Review.ReviewKey — NOT NULL
Plan (PLAN)
- PlanKey (Key) — INT — 기본 키 — NOT NULL
- PlanName (Field) — VARCHAR
- PlaceKey (Key2) — INT — 외래 키 → Place.PlaceKey — NOT NULL
- UserKey (Key3) — INT — 외래 키 → User.UserKey — NOT NULL
Profile (PROFILE)
- ProfileKey (Key) — INT — 기본 키 — NOT NULL
- Name (Field) — VARCHAR
- NickName (Field2) — VARCHAR
- Address (Field3) — VARCHAR
- E-mail (Field4) — VARCHAR
- Birth (Field5) — Date
- UserKey (Key2) — INT — 외래 키 → User.UserKey — NOT NULL
Recommend AI (Recommend_AI)
- AiKey (Key) — INT — 기본 키 — NOT NULL
Review (REVIEW)
- ReviewKey (Key) — INT — 기본 키 — NOT NULL
- ReviewContent (Field) — VARCHAR
- UserKey (Key2) — INT — 외래 키 → User.UserKey — NOT NULL
Tag (TAG)
- TagKey (Key) — INT — 기본 키 — NOT NULL
- TagName (Field) — VARCHAR
User (USER)
- UserKey (Key) — INT — 기본 키 — NOT NULL
- ID (Field) — VARCHAR
- Password (Field2) — VARCHAR