used transaction

Tables (5)

CHATMESSAGE (Untitled4)

  • MESSAGE_ID (Key) — NUMBER(10) — Primary key — NOT NULL
  • CLIENT_ID (client_id) — NUMBER(13) — Foreign key → CLIENT_INFO.CLIENT_ID — NOT NULL
  • ROOM_ID (Key2) — NUMBER(10) — Foreign key → CHATROOM.ROOM_ID — NOT NULL
  • MESSAGE_CONTENTS (Field) — VARCHAR2(100)
  • SENDTIME (Field2) — TIMESTAMP
  • CLIENT_NAME (Field4) — VARCHAR2(50)

CHATROOM (Untitled3)

  • ROOM_ID (Key) — NUMBER(10) — Primary key — NOT NULL
  • SELLER_ID — NUMBER(13,0)
  • BUYER_ID — NUMBER(13,0)

CLIENT_INFO (Untitled)

  • CLIENT_ID (client_id) — NUMBER(13) — Primary key — NOT NULL
  • CLIENT_PW (client_pw) — VARCHAR2(30)
  • CLIENT_NAME (client_name) — VARCHAR2(50)
  • REGION_ID (region_id) — VARCHAR2(50)
  • RELIABLIITY (reliabliity) — NUMBER(3)

FILE_T (Untitled5)

  • PRODUCT_ID (Key) — NUMBER(10) — Primary key — NOT NULL
  • File_Name — varchar2(50)
  • ori_name — varchar2(50)

PRODUCT (Untitled2)

  • PRODUCT_ID (Key) — NUMBER(10) — Primary key — NOT NULL
  • CLIENT_ID (client_id) — NUMBER(13) — Foreign key → CLIENT_INFO.CLIENT_ID — NOT NULL
  • PRODUCT_ID (Key3) — NUMBER(10) — Foreign key → FILE_T.PRODUCT_ID — NOT NULL
  • PRODUCT_NAME (Field) — VARCHAR2(50)
  • PRODUCT_DESCRIPTION (Field2) — VARCHAR(200)
  • CLIENT_ID (Field3) — NUMBER(13)
  • PRICE (Field4) — NUMBER(9)