secondhand

Tables (7)

product_comment (Untitled5)

  • comment_id (pk) — number — Primary key — NOT NULL
  • product_num (fk) — number — Foreign key → transaction_product.product_num — NOT NULL
  • user_id (fk2) — varchar2 — Foreign key → transaction_user.user_id — NOT NULL
  • comment_content (Field3) — varchar2
  • comment_date (Field4) — timestamp

region_codes (Untitled2)

  • code (pk) — varchar2 — Primary key — NOT NULL
  • name (Field) — varchar2
  • is_active (Field2) — char

transaction_category (Untitled3)

  • category_num (pk) — number — Primary key — NOT NULL
  • category_code (Field) — varchar2
  • category_name (Field2) — varchar2

transaction_chat_messages (Untitled4)

  • message_id (pk) — number — Primary key — NOT NULL
  • from_user (Field) — varchar2
  • to_user (Field2) — varchar2
  • product_num (Field3) — number
  • message (Field4) — clob
  • sent_time (Field5) — timestamp
  • is_read (Field6) — number
  • chat_room_num (Field7) — number
  • is_leave (Field8) — number

transaction_product (Untitled7)

  • product_num (pk) — number — Primary key — NOT NULL
  • user_id (fk) — varchar2 — Foreign key → transaction_user.user_id — NOT NULL
  • category_code (fk2) — varchar2 — Foreign key → transaction_category.category_num — NOT NULL
  • product_name (Field2) — varchar2 — NOT NULL
  • product_date (Field3) — date — NOT NULL
  • product_img (Field4) — varchar2
  • product_des (Field5) — varchar2
  • sales_price (Field7) — number
  • sales_area (Field8) — varchar2
  • product_title (Field9) — varchar2
  • product_hits (Field10) — number
  • product_status (Field11) — varchar2

transaction_report (Untitled6)

  • report_num (pk) — number — Primary key — NOT NULL
  • product_num (fk) — number — Foreign key → transaction_product.product_num — NOT NULL
  • reporter_id (Field2) — varchar2
  • reported_user_id (Field3) — varchar2
  • reported_at (Field4) — date
  • report_reason (Field5) — varchar2

transaction_user (Untitled)

  • user_id (pk) — varchar2 — Primary key — NOT NULL
  • user_pwd (Field) — varchar2
  • user_name (Field2) — varchar2
  • user_nickname (Field3) — varchar2
  • user_age (Field4) — number
  • user_email (Field5) — varchar2
  • user_phone (Field6) — varchar2
  • user_zipcode (Field7) — varchar2
  • user_addr (Field8) — varchar2
  • user_addr_detail (Field9) — varchar2
  • user_regdate (Field10) — date