CARPING

Tables (6)

C_REPLY

  • CR_NUM — NUMBER — Primary key — NOT NULL
  • C_NUM — NUMBER — Foreign key → Community.C_NUM — NOT NULL
  • ID — VARCHAR2 — Foreign key → Community.ID — NOT NULL
  • NICK — VARCHAR2 — Foreign key → Community.NICK — NOT NULL
  • CR_CONTENT — VARCHAR2
  • CR_DATE — DATE

Community (COMMUNITY)

  • C_NUM — NUMBER — Primary key — NOT NULL
  • ID — VARCHAR2 — Foreign key → User.ID — NOT NULL
  • NICK — VARCHAR2 — Foreign key → User.NICK — NOT NULL
  • C_IMG — VARCHAR2
  • C_CONTENT — VARCHAR2
  • C_DATE — DATE
  • C_LIKE — NUMBER

SPOT

  • S_NUM — NUMBER — Primary key — NOT NULL
  • S_NAME — VARCHAR2
  • S_ADDR — VARCHAR2
  • S_LAT — NUMBER
  • S_LONG — NUMBER
  • S_TYPE — VARCHAR2
  • S_AMENITY — VARCHAR2
  • S_IMG — VARCHAR2
  • S_TEL

USED_ITEM (USER_ITEM)

  • U_NUM — NUMBER — Primary key — NOT NULL
  • ID — VARCHAR2 — Foreign key → User.ID — NOT NULL
  • NICK — VARCHAR2 — Foreign key → User.NICK — NOT NULL
  • U_TITLE — VARCHAR2
  • U_CONTENT — VARCHAR2
  • U_PRICE — NUMBER
  • U_STATE — VARCHAR2
  • U_DATE — DATE

U_REPLY

  • UR_NUM — NUMBER — Primary key — NOT NULL
  • U_NUM — NUMBER — Foreign key → USED_ITEM.U_NUM — NOT NULL
  • ID — VARCHAR2 — Foreign key → USED_ITEM.ID — NOT NULL
  • NICK — VARCHAR2 — Foreign key → USED_ITEM.NICK — NOT NULL
  • UR_CONTENT — VARCHAR2
  • UR_DATE — DATE

User (USER)

  • ID — VARCHAR2 — Primary key — NOT NULL
  • NICK — VARCHAR2 — Primary key — NOT NULL
  • PW — VARCHAR2
  • NAME — VARCHAR2
  • TEL — VARCHAR2
  • ADDR — VARCHAR2
  • GENDER — VARCHAR2