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