캡스톤_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