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)