마이군위캡슐4/20

테이블 (10)

ADMINISTRATOR

  • ADMINISTRATOR_ID (Key) — 기본 키 — NOT NULL
  • RANK (Field)
  • NAME (Field2)
  • PHONE (Field3)
  • EMAIL (Field4)

CAPSULE_ROUTE_RELATION

  • CAPSULE_ID (Key2) — 외래 키 → TOURIST_CAPSULE.CAPSULE_ID — NOT NULL
  • ROUTE_ID (Key3) — 외래 키 → TOURIST_ROUTE.ROUTE_ID — NOT NULL

LOCAL_BUSINESS

  • USER_ID (Key) — 기본 키 — NOT NULL
  • PW (Field2)
  • MEMBERSHIP_DATE (Field4)
  • NAME (Field5)
  • BIRTHDAY (Field7)
  • EMAIL (Field6)
  • ADRESS (Field3)

LOCAL_BUSINESS_CAPSULE

  • BUSINESS_ID (Key) — 기본 키 — NOT NULL
  • USER_ID (Key2) — 외래 키 → LOCAL_BUSINESS.USER_ID — NOT NULL
  • BUSINESS_NAME (Field)
  • ADRESS (Field2)
  • PHONE (Field3)

LOCAL_BUSINESS_REQUEST

  • REQUEST_ID (Key2) — 기본 키 — NOT NULL
  • USER_ID (Key) — 외래 키 → LOCAL_BUSINESS.USER_ID — NOT NULL
  • BUSINESS_ID (Key3) — 외래 키 → LOCAL_BUSINESS_CAPSULE.BUSINESS_ID — NOT NULL
  • TITLE (Field2)
  • CONTENTS (Field3)
  • PICTURE (Field4)
  • APPLIED (Field)

LOCAL_INFORMATION_CAPSULE

  • CAPSULE_ID (Key2) — 기본 키 — NOT NULL
  • ADMINISTRATIOR_ID (Key) — 외래 키 → ADMINISTRATOR.ADMINISTRATOR_ID — NOT NULL
  • TITLE (Field)
  • CONTENTS (Field2)
  • POSITION (Field5)
  • MUTIMEDIA_FILE (Field3)
  • OPENING_HOURS (Field4)
  • ADMISSION_FEE (Field6)

RECOMMENDED_ROUTE

  • RECOMMENDED_ROUTE_ID (Key) — 기본 키 — NOT NULL

TOURIST

  • USER_ID (Key) — 기본 키 — NOT NULL
  • PW (Field2)
  • MEMBERSHIP_DATE (Field4)
  • NAME (Field5)
  • EMAIL (Field6)
  • BIRTHDAY (Field7)

TOURIST_CAPSULE

  • CAPSULE_ID (Key2) — 기본 키 — NOT NULL
  • USER_ID (Key) — 외래 키 → TOURIST.USER_ID — NOT NULL
  • POSITION (Field5)
  • PICTURE (Field3)
  • CONTENTS (Field2)

TOURIST_ROUTE

  • ROUTE_ID (Key) — 기본 키 — NOT NULL
  • USER_ID (Key2) — 외래 키 → TOURIST.USER_ID — NOT NULL
  • DATE (Field)