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