CoffeeZone
Tables (5)
ADMIN (admin)
- ASEQ (aseq) — SEQUENCE — Primary key — NOT NULL
- AID (aid) — VARCHAR2(20)
- PWD (pwd) — VARCHAR2(20)
- ANMAE (aname) — VARCHAR2(20)
MEMBERS (members)
- MSEQ (mesq) — SEQUENCE — Primary key — NOT NULL
- MID (mid) — VARCAHAR2(20)
- PWD (pwd) — VARCHAR2(20)
- MNAME (name) — VARCHAR2(20)
- GENDER (gender) — NUMBER
- BIRTH (birth) — DATE
- EMAIL (email) — VARCHAR2(50)
- PHONE (phone) — VARCHAR2(20)
ORDERPAY (orderpay)
- OSEQ (oseq) — SEQUENCE — Primary key — NOT NULL
- PSEQ (pseq) — SEQUENCE — Primary key — NOT NULL
- PRICE (price) — NUMBER(8)
- QUANTUTY (quantity) — NUMBER
- IMAGED (image) — VARCHAR2(100)
- OSEQ (oseq2) — SEQUENCE — Foreign key → ORDERS.OSEQ — NOT NULL
- PSEQ (pseq2) — SEQUENCE — Foreign key → PRODUCT.PSEQ — NOT NULL
ORDERS (orders)
- OSEQ (oseq) — SEQUENCE — Primary key — NOT NULL
- TOTAL_PRICE (total_price) — NUMBER
- ORDER_TIME (order_time) — DATE
- ORDER_STATUS (order_statue) — NUMBER
- PAY_TYPE (pay_type) — VARCHAR2(3)
- PAY_STATUS (pay_status) — VARCHAR2(5)
- PSEQ (pseq) — SEQUENCE — Foreign key → PRODUCT.PSEQ — NOT NULL
- MSEQ (mesq) — SEQUENCE — Foreign key → MEMBERS.MSEQ — NOT NULL
PRODUCT (product)
- PSEQ (pseq) — SEQUENCE — Primary key — NOT NULL
- PNAME (pname) — VARCHAR2(50)
- CATEGORY (category) — VARCHAR2(30)
- PRICE (price) — NUMBER(10)
- REGDAY (reg_day) — DATE
- IMAGED (image) — VARCHAR2(100)
- HT_KIND (ht)