shop2

Tables (5)

MEMBER

  • ID — VARCHAR(20) — Primary key — NOT NULL
  • PWD — VARCHAR2(20) — NOT NULL
  • NAME — VARCHAR2(50) — NOT NULL
  • ADDRESS — VARCHAR2(7)
  • ZIPCODE — VARCHAR2(7) — Foreign key → Untitled.ZIPCODE — NOT NULL
  • TEL — VARCHAR2(13)
  • INDATE — DATE

ORDERS

  • O_SEQ — NUMBER(10) — Primary key — NOT NULL
  • PRODUCT_CODE — VARCHAR2(20)
  • PRODUCT_SIZE — VARCHAR2(5)
  • QUANTITY — VARCHAR2(5)
  • RESULT — CHAR(1)
  • INDATE — DATE
  • PRODUCT_CODE2 — VARCHAR2(20) — Foreign key → PRODUCTS.PRODUCT_CODE — NOT NULL
  • ID — VARCHAR(16) — Foreign key → MEMBER.ID — NOT NULL

PRODUCTS

  • PRODUCT_CODE — VARCHAR2(20) — Primary key — NOT NULL
  • PRODUCT_NAME — VARCHAR2(100)
  • PRODUCT_KIND — CHAR(1)
  • PRODUCT_PRICE1 — VARCHAR2(10)
  • PRODUCT_PRICE2 — VARCHAR2(10)
  • PRODUCT_CONTENT — VARCHAR2(1000)
  • PRODUCT_IMAGE — VARCHAR2(50)
  • SIZEST — VARCHAR2(5)
  • SIZEET — VARCHAR2(5)
  • PRODUCT_QUANTITY — VARCHAR2(5)
  • USEYN — CHAR(1)
  • Field7 — VARCHAR(255)

SAMPLE

  • FIELD — VARCHAR2(30)
  • Field2
  • Field3
  • Field4
  • Field5

Untitled

  • ZIPCODE — VARCHAR2(7) — Primary key — NOT NULL
  • SIDO — VARCHAR2(30)
  • GUGUN — VARCHAR2(30)
  • DONG — VARCHAR2(30)
  • BUNGI — VARCHAR2(30)