바스켓
테이블 (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)