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)