market2
Tables (6)
CATEGORY
- CATEGORY_ID — NUMBER — Primary key
- CATEGORY_NAME — VARCHAR2(100) — NOT NULL
COMMENT
- COMMENT — PRIMARY — Primary key — RIMARY KEY (COMMENT_ID
- _ID — NUMBER
- USER_ID — VARCHAR2(255)
- CONTENT — CLOB — NOT NULL
- CREATED_AT — TIMESTAMP
FAVORITE
- USER_ID — VARCHAR2(255) — Primary key
- POST_ID — NUMBER
- CREATED_AT — TIMESTAMP
POST
- POST_ID — NUMBER — Primary key
- USER_ID — VARCHAR2(255)
- CATEGORY_ID — NUMBER
- TITLE — VARCHAR2(255) — NOT NULL
- CONTENT — CLOB — NOT NULL
- PRICE — NUMBER(10, 2) — NOT NULL
- CONDITION — VARCHAR2(50)
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
TRANSACTION_HISTORY
- TRANSACTION_ID — NUMBER — Primary key
- BUYER_ID — VARCHAR2(255)
- SELLER_ID — VARCHAR2(255)
- POST_ID — NUMBER
- TRANSACTION_DATE — TIMESTAMP
USERS
- USER_ID — VARCHAR2(255) — Primary key
- EMAIL — VARCHAR2(255) — NOT NULL
- USERNAME — VARCHAR2(100) — NOT NULL
- PHONE_NUMBER — VARCHAR2(20)
- ADDRESS — VARCHAR2(255)
- CREATED_AT — TIMESTAMP