SQLD2

Tables (6)

CONTENTS

  • CONTENTS_UID — NUMBER — Primary key — NOT NULL
  • CONTENTS_NAME — VARCHAR2(150)

INVENTORY MANAGEMENT

  • INVENTORY MANAGEMENT_UID — NUMBER — Primary key — NOT NULL
  • INVENTORY MANAGEMENT_NAME — VARCHAR2(150)
  • INVENTORY MANAGEMENT_QNT — NUMBER

PAY MENT

  • PAY MENT_UID — NUMBER — Primary key — NOT NULL
  • PAY MENT_NAME — VARCHAR2(200)

PRODUCT

  • PRODUCT_UID — NUMBER — Primary key — NOT NULL
  • PRODUCTTYPE_UID — NUMBER — Foreign key → PRODUCT TYPE.PRODUCTTYPE_UID — NOT NULL
  • UESR_UID — NUMBER — Foreign key → UESR.UESR_UID — NOT NULL
  • CONTENTS_UID — NUMBER — Foreign key → CONTENTS.CONTENTS_UID — NOT NULL
  • INVENTORY MANAGEMENT_UID — NUMBER — Foreign key → INVENTORY MANAGEMENT.INVENTORY MANAGEMENT_UID — NOT NULL
  • PAY MENT_UID — NUMBER — Foreign key → PAY MENT.PAY MENT_UID — NOT NULL
  • PRODUCT_NAME — VARCHAR2(150)
  • PRODUCT_PRICE — NUMBER
  • PRODUCT_SALES_PRICE — NUMBER
  • PRODUCT_DESSCRIPTION — VARCHAR2(200) — 설명
  • PRODUCT_QNT — NUMBER

PRODUCT TYPE

  • PRODUCTTYPE_UID — NUMBER — Primary key — NOT NULL
  • PRODUCTTYPE_NAME — VARCHAR2(150)

UESR

  • UESR_UID — NUMBER — Primary key — NOT NULL
  • UESR_ID — VARCHAR2(150)
  • UESR_PASSWORD — VARCHAR2(150)
  • UESR_SEX — VARCHAR2(50)
  • UESR_BIRTH — VARCHAR2(100)
  • UESR_NAME — VARCHAR2(150)
  • UESR_MOBILE — NUMBER
  • UESR_ZIPCODE — NUMBER
  • UESR_ADD1 — VARCHAR2(150)
  • UESR_ADD2 — VARCHAR2(150)
  • UESR_COMMENT — VARCHAR2(200)