KG쇼핑
테이블 (14)
admins
- admins_idx — number — 기본 키 — NOT NULL
- admins_username — varchar2(100)
- admins_password — varchar2(100) — NOT NULL
- admins_name — varchar2(100) — NOT NULL
cart
- cart_idx — number — 기본 키 — NOT NULL
- added_date — date — NOT NULL
- quantity — number — NOT NULL
- color_idx (color_idx2) — number — 외래 키 → color.color_idx — NOT NULL
- size_idx — number — 외래 키 → size_table.size_idx — NOT NULL
- products_idx (products_idx2) — number — 외래 키 → products.products_idx — NOT NULL
- members_idx (members_idx2) — number — 외래 키 → members.members_idx
categories
- categories_idx — number — 기본 키 — NOT NULL
- categories_name — varchar2(255) — NOT NULL
- categories_idx (categories_idx2) — number — 외래 키 → categories.categories_idx — NOT NULL
color
- color_idx — number — 기본 키 — NOT NULL
- color — VARCHAR2(50) — NOT NULL
favorites
- favorites_idx — number — 기본 키 — NOT NULL
- products_idx (products_idx2) — number — 외래 키 → products.products_idx — NOT NULL
- members_idx (members_idx2) — number — 외래 키 → members.members_idx
inquiries
- inquiries_idx — number — 기본 키 — NOT NULL
- inquiries_title — varchar2(200) — NOT NULL
- inquiries_registration_date — date — NOT NULL
- inquiries_content — varchar2(500) — NOT NULL
- inquiries_image_url — varchar2(500)
- inquiries_category — varchar2(100) — NOT NULL
- members_idx (members_idx2) — number — 외래 키 → members.members_idx
- products_idx — number — 외래 키 → products.products_idx — NOT NULL
members
- members_idx — number — 기본 키
- members_id — varchar2(30) — NOT NULL
- members_password — varchar2(255) — NOT NULL
- members_nickname — varchar2(100) — NOT NULL
- members_email — varchar2(100) — NOT NULL
- members_address_number — varchar2(300) — NOT NULL
- members_address — varchar2(300) — NOT NULL
- members_detailed_address — varchar2(300) — NOT NULL
- members_address_building — varchar2(300)
- members_phone_number — varchar2(13) — NOT NULL
- members_name — varchar2(50) — NOT NULL
- members_ssn — number — NOT NULL
- members_is_withdrawn — varchar2(1)
- members_points — number
- members_join_date — date
orders
- orders_idx — number — 기본 키 — NOT NULL
- orders_date — date — NOT NULL
- orders_status — varchar2(100)
- orders_recipient_name — varchar2(50) — NOT NULL
- orders_address_number — varchar2(300) — NOT NULL
- orders_address — varchar2(300) — NOT NULL
- orders_detailed_address — varchar2(300) — NOT NULL
- orders_address_building — varchar2(300)
- orders_recipient_phone — varchar2(13) — NOT NULL
- orders_delivery_notes — varchar2(300)
- orders_total_price — number — NOT NULL
- members_idx (members_idx2) — number — 외래 키 → members.members_idx
ordersd_details
- ordersd_details — number — 기본 키 — NOT NULL
- quantity — number — NOT NULL
- orders_idx — number — 외래 키 → orders.orders_idx — NOT NULL
- color_idx — number — 외래 키 → color.color_idx — NOT NULL
- size_idx (size_idx2) — number — 외래 키 → size_table.size_idx — NOT NULL
- products_idx (products_idx2) — number — 외래 키 → products.products_idx — NOT NULL
products
- products_idx — number — 기본 키 — NOT NULL
- products_name — varchar2(300) — NOT NULL
- products_description — varchar2(500) — NOT NULL
- products_price — number — NOT NULL
- products_registration_date — date — NOT NULL
- products_stock — number — NOT NULL
- products_is_deleted — varchar2(1)
- categories_idx (categories_idx2) — number — 외래 키 → categories.categories_idx — NOT NULL
products_color
- color_idx (color_idx2) — number — 외래 키 → color.color_idx — NOT NULL
- products_idx (products_idx2) — number — 외래 키 → products.products_idx — NOT NULL
products_img
- products_img_idx — number — 기본 키 — NOT NULL
- img_url — varchar2(500) — NOT NULL
- products_idx (products_idx2) — number — 외래 키 → products.products_idx — NOT NULL
products_size
- size_idx (size_idx2) — number — 외래 키 → size_table.size_idx — NOT NULL
- products_idx — number — 외래 키 → products.products_idx — NOT NULL
size_table
- size_idx — number — 기본 키 — NOT NULL
- size_product — VARCHAR2(50) — NOT NULL