바스켓

테이블 (14)

Untitled (member_detail)

  • Key (mem_code(FK)) — number — 외래 키 → member.Key — NOT NULL
  • Field (mem_gender) — varchar2(10)
  • Field (mem_birth) — varchar2(20)
  • Field (mem_tel) — varchar2(20)
  • Field (mem_enterance) — varchar2(100)

Untitled (store)

  • Key (sto_code(PK)) — number — 기본 키 — NOT NULL
  • Field (sto_name) — varchar2(20)
  • Field (sto_tel) — varchar2(20)
  • Field (sto_addr) — varchar2(100)
  • Field (sto_img) — varchar2(100)
  • Field (lng) — number(25.20)
  • Field (lat) — number(25.20)
  • Field (sto_qrcode) — varchar2(100)
  • Field (sto_uuid) — varchar2(100)
  • Field (sto_major) — number
  • Field (sto_time) — varchar2(20)

Untitled (admin)

  • Key (sto_code(FK)) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (admin_id) — varchar2(20)
  • Field (admin_pw) — varchar2(20)
  • Field (admin_name) — varchar2(20)
  • Field (admin_tel) — varchar2(20)
  • Field (admin_email) — varchar2(30)

Untitled (product)

  • Key (pro_code(PK)) — number — 기본 키 — NOT NULL
  • Key (sto_code(FK)) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (pro_name) — varchar2(200)
  • Field (pro_price) — number
  • Field (pro_img) — varchar2(300)
  • Field (pro_barcode) — varchar2(100)
  • Field (sales_status) — varchar2(20)

Untitled (payment)

  • Key (pay_code(PK)) — number — 기본 키 — NOT NULL
  • Key (sto_code(FK)) — number — 외래 키 → Untitled.Key — NOT NULL
  • Key (mem_code(FK)) — number — 외래 키 → member.Key — NOT NULL
  • Key (eve_code(FK)) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (pay_date) — varchar2(20)
  • Field (pay_method) — varchar2(20)
  • Field (pay_status) — varchar2(20)
  • Field (pay_value) — number

Untitled (payment_detail)

  • Key (pro_code(FK)) — number — 외래 키 → Untitled.Key — NOT NULL
  • Key (pay_code(FK)) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (pro_price) — number
  • Field (PAY_EA) — number

Untitled (event)

  • Key (eve_code(PK)) — number — 기본 키 — NOT NULL
  • Key (sto_code(PK)) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (eve_name) — varchar2(100)
  • Field (eve_img) — varchar2(500)
  • Field (eve_detail_img) — varchar2(500)
  • Field (eve_des) — varchar2(1000)
  • Field (eve_start) — varchar2(20)
  • Field (eve_end) — varchar2(20)
  • Field (discount_for) — number
  • Field (discount_price) — number
  • Field (is_del) — char(1BYTE)

Untitled (coupon_history)

  • Key (eve_code(FK)) — number — 외래 키 → Untitled.Key — NOT NULL
  • Key (mem_code(PK)) — number — 외래 키 → member.Key — NOT NULL

Untitled (supplier)

  • Key (sup_code(PK)) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (sto_code(FK)) — varchar2(20)
  • Field (sup_name) — varchar2(20)
  • Field (suo_manager) — varchar2(20)
  • Field2 (sup_mgr_tel) — varchar2(20)
  • Field (sup_emial) — varchar2(50)

Untitled (supplier_detail)

  • Key (sto_code(PK)) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (sup_code(FK)) — number
  • Field (sup_ceo) — varchar2(20)
  • Field (sup_tel) — varchar2(20)
  • Field (sup_addr) — varchar2(100)
  • Field (businesscategory) — varchar2(20)

Untitled (product_detail)

  • Key (pro_code(FK)) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (pro_category1) — varchar2(20)
  • Field (pro_category2) — varchar2(20)
  • Field (pro_stock_ea) — number

Untitled (purchasing)

  • Key (pur_code(PK)) — number — 기본 키 — NOT NULL
  • Key (pro_code(FK)) — number — 외래 키 → Untitled.Key — NOT NULL
  • Key (sto_code(FK)) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (sup_code) — number
  • Field (pur_date) — varchar(20)
  • Field (pur_price) — number
  • Field (pur_ea) — number

Untitled2 (fav_store)

  • Key (mem_code(FK)) — number — 외래 키 → member.Key — NOT NULL
  • Key (sto_code(FK)) — number — 외래 키 → Untitled.Key — NOT NULL

member

  • Key (mem_code(PK)) — number — 기본 키 — NOT NULL
  • Field (mem_name) — varchar2(20)
  • Field (mem_email) — varchar2(50)
  • Field (mem_pw) — varchar2(20)
  • Field (mem_age) — number
  • Field (is_del) — char(1byte)