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