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)