e-ecomerce shop
Tables (11)
ADDRESS
- ADDRESS_NO — NUMBER
- ADDRESS_ZIP — CHAR(7) — NOT NULL
- ADDRESS_ADD1 — VARCHAR2(100) — NOT NULL
- ADDRESS_ADD2 — VARCHAR2(80) — NOT NULL
- MEM_NO — NUMBER(10) — NOT NULL
CART
- CART_NO — VARCHAR2(15)
- MEM_NO — NUMBER(10) — NOT NULL
DELIVERY
- DELIVERY_NO — NUMBER(10)
- DELIVERY_IMG — VARCHAR2(40) — NOT NULL
- PAY_NO — NUMBER(10) — NOT NULL
LPROD
- LPROD_ID — NUMBER(7)
- LPROD_GU — CHAR(4) — NOT NULL
- LPROD_NM — VARCHAR2(40) — NOT NULL
MEMBER
- MEM_NO — NUMBER(10)
- MEM_ID — VARCHAR2(15) — NOT NULL
- MEM_PASS — VARCHAR2(15) — NOT NULL
- MEM_NAME — VARCHAR2(20) — NOT NULL
- MEM_ZIP — CHAR(7) — NOT NULL
- MEM_ADD1 — VARCHAR2(100) — NOT NULL
- MEM_ADD2 — VARCHAR2(80) — NOT NULL
- MEM_TEL — VARCHAR2(15)
- MEM_MAIL — VARCHAR2(40) — NOT NULL
- MEM_MEMORIAL_Q — VARCHAR2(40)
- MEM_MEMORIAL_A — DATE
- MEM_DELETE — VARCHAR2(1)
- ZIP_NO — NUMBER — NOT NULL
- ADDRESS_NO — NUMBER — NOT NULL
- DELIVERY_NO — NUMBER(10) — NOT NULL
MEMBERSHIP
- MEMBERSHIP_NO — NUMBER(10)
- MEMBERSHIP_CODE — VARCHAR2(1)
- MEMBERSHIP_HIRE_DATE — DATE — NOT NULL
- MEMBERSHIP_RETIRE_DATE — DATE
- MEMBERSHIP_DELETE — VARCHAR2(1)
- MEMBERSHIP_BANK_NAME — VARCHAR2(20)
- MEMBERSHIP_BANK_NO — VARCHAR2(30)
- MEMBERSHIP_CARD_NAME — VARCHAR2(20)
- MEMBERSHIP_CARD_NO — VARCHAR2(30)
- MEMBERSHIP_CARD_CVC — VARCHAR2(30)
- MEMBERSHIP_CARD_PASS — VARCHAR2(30)
- MEMBERSHIP_DISCOUNT_RATE — NUMBER(2,2)
- MEM_NO — NUMBER(10) — NOT NULL
PAY
- PAY_NO — NUMBER(7)
- PAY_DATE — DATE — NOT NULL
- PAY_AMT — NUMBER(20) — NOT NULL
- PAY_FINALPRICE — NUMBER(20) — NOT NULL
- CART_NO — VARCHAR2(15) — NOT NULL
PROD
- PROD_ID — VARCHAR2(10)
- PROD_NAME — VARCHAR2(40) — NOT NULL
- PROD_CONTENT — VARCHAR2(40) — NOT NULL
- PROD_LGU — CHAR(4) — NOT NULL
- PROD_COST — NUMBER(10) — NOT NULL
- PROD_PRICE — NUMBER(10) — NOT NULL
- PROD_IMG — VARCHAR2(40) — NOT NULL
- PROD_INSDATE — DATE — NOT NULL
- LPROD_ID — NUMBER(7) — NOT NULL
ZIP
- ZIP_NO — NUMBER
- ZIP_CODE — VARCHAR2(7) — NOT NULL
- ZIP_SIDO — VARCHAR2(6) — NOT NULL
- ZIP_GUGUN — VARCHAR2(30)
- ZIP_DONG — VARCHAR2(40)
- ZIP_RI — VARCHAR2(30)
- ZIP_BLDG — VARCHAR2(60)
- ZIP_BUNJI — VARCHAR2(30)
- MEM_NO — NUMBER(10) — NOT NULL