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