sys

Tables (6)

CATEGORY

  • CATEGORY_ID — NUMBER
  • CATEGORY_NAME — VARCHAR2(100) — NOT NULL

FAVORITE

  • USER_ID — VARCHAR2(255)
  • POST_ID — NUMBER
  • CREATED_AT — TIMESTAMP

POST

  • POST_ID — NUMBER
  • 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
  • BUYER_ID — VARCHAR2(255)
  • SELLER_ID — VARCHAR2(255)
  • POST_ID — NUMBER
  • TRANSACTION_DATE — TIMESTAMP

USERS

  • USER_ID — VARCHAR2(255)
  • EMAIL — VARCHAR2(255) — NOT NULL
  • USERNAME — VARCHAR2(100) — NOT NULL
  • PHONE_NUMBER — VARCHAR2(20)
  • ADDRESS — VARCHAR2(255)
  • CREATED_AT — TIMESTAMP

USER_COMMENT

  • COMMENT — PRIMARY — RIMARY KEY (COMMENT_ID
  • _ID — NUMBER
  • USER_ID — VARCHAR2(255)
  • CONTENT — CLOB — NOT NULL
  • CREATED_AT — TIMESTAMP