마이군위캡슐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)