meommemumme_ERD
Tables (10)
TBL_BOOKMARK (Untitled4)
- BOOKMARK_NAME (Key) — VARCHAR2 — Primary key — NOT NULL
- BOOKMARK_NICK (Key2) — VARCHAR2 — Foreign key → TBL_USER.USER_NICK — NOT NULL
- BOOKMARK_CATEGORY (Field) — VARCHAR2
- BOOKMARK_REGIST (Field2) — DATE
TBL_COMMENT (Untitled3)
- Key — Primary key — NOT NULL
TBL_COMMUNITY (Untitled2)
- COMMUNITY_NUMBER (Key) — NUMBER — Primary key — NOT NULL
- COMMUNITY_DATE (Field) — DATE
- COMMUNITY_HITS (Field2) — NUMBER
- COMMUNITY_CONTENTS (Field3) — VARCHAR2
- COMMUNITY_NICK (Field4) — VARCHAR2
- COMMUNITY_IMG (Field5) — VARCHAR2
- COMMUNITY_RECOMMEND (Field6) — NUMBER
- COMMUNITY_NICK (Key3) — VARCHAR2 — Foreign key → TBL_USER.USER_NICK — NOT NULL
TBL_FUNERAL (Untitled7)
- FUNERAL_NUM (Key) — NUMBER — Primary key — NOT NULL
- FUNERAL_ADDRESS (Field) — VARCHAR2
- FUNERAL_TEL (Field3) — VARCHAR2
- FUNERAL_HOUR (Field4) — VARCHAR2
- FUNERAL_HOLIDAY (Field5) — VARCHAR2
- FUNERAL_RATING (Field6) — NUMBER
- FUNERAL_NAME (Key2) — VARCHAR2 — Foreign key → TBL_BOOKMARK.BOOKMARK_NAME — NOT NULL
TBL_HOSPITAL (Untitled9)
- HOSPITAL_NUM (Key) — NUMBER — Primary key — NOT NULL
- HOSPITAL_ADDRESS (Field) — VARCHAR2
- HOSPITAL_TEL (Field2) — VARCHAR2
- HOSPITAL_HOUR (Field3) — VARCHAR2
- HOSPITAL_HOLIDAY (Field4) — VARCHAR2
- HOSPITAL_RATING (Field5) — NUMBER
- HOSPITAL_NAME (Key2) — VARCHAR2 — Foreign key → TBL_BOOKMARK.BOOKMARK_NAME — NOT NULL
TBL_MANAGER (Untitled)
- MANAGER_NUMBER (Key) — NUMBER — Primary key — NOT NULL
- MANAGER_ID (Field) — VARCHAR2
- MANAGER_PW (Field2) — VARCHAR2
TBL_PLAYGROUND (Untitled6)
- PLAYGROUND_NUM (Key) — NUMBER — Primary key — NOT NULL
- PLAYGROUND_ADDRESS (Field) — VARCHAR2
- PLAYGROUND_TEL (Field3) — VARCHAR2
- PLAYGROUND_HOUR (Field4) — VARCHAR2
- PLAYGROUND_HOLIDAY (Field5) — VARCHAR2
- PLAYGROUND_HOLIDAY (Field6) — VARCHAR2
- PLAYGROUND_RATING (Field7) — VARCHAR2
- PLAYGROUND_NAME (Key2) — VARCHAR2 — Foreign key → TBL_BOOKMARK.BOOKMARK_NAME — NOT NULL
TBL_SANCTUARY (Untitled8)
- SANCTUARY_NUM (Key) — NUMBER — Primary key — NOT NULL
- SANCTUARY_ADDRESS (Field) — VARCHAR2
- SANCTUARY_TEL (Field3) — VARCHAR2
- SANCTUARY_HOUR (Field4) — VARCHAR2
- SANCTUARY_HOLIDAY (Field5) — VARCHAR2
- SANCTUARY_RATING (Field6) — NUMBER
- Field7
- SANCTUARY_NAME (Key2) — VARCHAR2 — Foreign key → TBL_BOOKMARK.BOOKMARK_NAME — NOT NULL
TBL_SHOP (Untitled5)
- SHOP_NUMBER (Key) — NUMBER — Primary key — NOT NULL
- SHOP_PRICE (Field2) — VARCHAR2
- SHOP_CATEGORY (Field3) — VARCHAR2
- SHOP_PICTURE (Field4) — VARCHAR2
- SHOP_REGIST (Field5) — DATE
- SHOP_CHECK (Field6) — NUMBER
- SHOP_RATING (Field7) — NUMBER
- SHOP_NAME (Key2) — VARCHAR2 — Foreign key → TBL_BOOKMARK.BOOKMARK_NAME — NOT NULL
TBL_USER
- USER_NICK (Key) — VARCHAR2 — Primary key — NOT NULL
- USER_NUMBER (Field) — NUMBER
- USER_ID (Field2) — VARCHAR2
- USER_PW (Field3) — VARCHAR2
- USER_NAME (Field4) — VARCHAR2
- USER_PN (Field5) — VARCHAR2
- USER_EMAIL (Field6) — VARCHAR2
- USER_ADDRESS (Field7) — VARCHAR2
- USER_ZIP (Field8) — VARCHAR2
- USER_PET (Field9) — VARCHAR2
- USER_REGIST (Field10) — DATE
- USER_BU (Field11) — NUMBER