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)