USM_ERD
Tables (4)
CHAT_MESSAGE (Untitled5)
- MESSAGE_ID (Key) — NUMBER(10,0) — Primary key — NOT NULL
- CLIENT_ID (Key2) — NUMBER(13,0) — Foreign key → CLIENT_INFO.CLIENT_ID — NOT NULL
- MESSAGE_CONTENTS (Field) — VARCHAR2(100 BYTE)
- SENDTIME (Field2) — TIMESTAMP(6)
- CLIENT_ID (Field3) — NUMBER(13,0)
CHAT_ROOM (Untitled4)
- ROOM_ID (Key) — NUMBER(10,0) — Primary key — NOT NULL
CLIENT_INFO (Untitled)
- CLIENT_ID (Key) — NUMBER(13,0) — Primary key — NOT NULL
- CLIENT_PW (Field2) — VARCHAR2(30 BYTE)
- CLIENT_NAME (Field3) — VARCHAR2(50 BYTE)
- REGION_ID (Field) — VARCHAR2(50 BYTE)
- RELIABILITY (Field4) — NUMBER(3,0)
PRODUCT (Untitled2)
- PRODUCT_ID (Key) — NUMBER(10,0) — Primary key
- CLIENT_ID (Key2) — NUMBER(13,0) — Foreign key → CLIENT_INFO.CLIENT_ID — NOT NULL
- PRODUCT_NAME (Field) — VARCHAR2(50 BYTE)
- PRODUCT_DESCRIPTION (Field2) — VARCHAR2(200 BYTE)
- PRICE (Field3) — NUMBER(9,0)
- REGION_ID (Field4) — VARCHAR2(50 BYTE)