쇼핑몰.1

테이블 (22)

banner

  • id — bigint(20) — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • image — varchar(255)
  • url — varchar(255) — NOT NULL
  • type — varchar(255) — NOT NULL
  • visible — bit(1) — NOT NULL
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL

banner_click

  • id — bigint(20) — 기본 키 — NOT NULL
  • banner_id — bigint(20) — 외래 키 → banner.id — NOT NULL
  • click_count — int(11) — NOT NULL
  • date_created — datetime — NOT NULL
  • ip — varchar(255) — NOT NULL

brand

  • id — bigint(20) — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • logo — varchar(255)
  • enabled — bit(1) — NOT NULL

brand_info

  • id — bigint(20) — 기본 키 — NOT NULL
  • brand_id — bigint(20) — 외래 키 → brand.id — NOT NULL
  • description — longtext
  • email — varchar(255) — NOT NULL
  • homepage_url — varchar(255)
  • tel — varchar(255) — NOT NULL

cart

  • id — bigint(20) — 기본 키 — NOT NULL
  • user_id — bigint(20) — 외래 키 → user.id — NOT NULL
  • product_id — bigint(20) — 외래 키 → product.id — NOT NULL
  • quantity — int(11) — NOT NULL
  • date_added — datetime — NOT NULL

category

  • code — varchar(255) — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • parent_code — varchar(255) — 외래 키 → category.code
  • sort_order — int(11) — NOT NULL
  • enabled — bit(1) — NOT NULL

confirm_email

  • id — bigint(20) — 기본 키 — NOT NULL
  • user_id — bigint(20) — 외래 키 → user.id — NOT NULL
  • email — varchar(255) — NOT NULL
  • secured_key — varchar(255) — NOT NULL
  • date_expired — datetime — NOT NULL

file

  • id — bigint(20) — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • org_name — varchar(255) — NOT NULL
  • type — varchar(255) — NOT NULL
  • byte_size — int(11) — NOT NULL
  • width — int(11) — NOT NULL
  • height — int(11) — NOT NULL

inventory

  • id — bigint(20) — 기본 키 — NOT NULL
  • product_id — bigint(20) — 외래 키 → product.id — NOT NULL
  • size — varchar(50)
  • color — varchar(50)
  • stock_quantity — int(11) — NOT NULL

logged_in

  • id — bigint(20) — 기본 키 — NOT NULL
  • user_id — bigint(20) — 외래 키 → user.id — NOT NULL
  • date_created — datetime — NOT NULL
  • remote_addr — varchar(255)

notification

  • id — bigint(20) — 기본 키 — NOT NULL
  • user_id — bigint(20) — 외래 키 → user.id — NOT NULL
  • product_id — bigint(20) — 외래 키 → product.id
  • type — varchar(255) — NOT NULL
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL

order

  • id — bigint(20) — 기본 키 — NOT NULL
  • user_id — bigint(20) — 외래 키 → user.id — NOT NULL
  • total_amount — decimal(10,2) — NOT NULL
  • status — varchar(50) — NOT NULL
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL
  • shipping_address — varchar(255) — NOT NULL

order_item

  • id — bigint(20) — 기본 키 — NOT NULL
  • order_id — bigint(20) — 외래 키 → order.id — NOT NULL
  • product_id — bigint(20) — 외래 키 → product.id — NOT NULL
  • quantity — int(11) — NOT NULL
  • unit_price — decimal(10,2) — NOT NULL

product

  • id — bigint(20) — 기본 키 — NOT NULL
  • category_code — varchar(255) — 외래 키 → category.code — NOT NULL
  • brand_id — bigint(20) — 외래 키 → brand.id
  • title — varchar(255) — NOT NULL
  • price — decimal(10,2) — NOT NULL
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL
  • view_count — int(11) — NOT NULL
  • review_count — int(11) — NOT NULL
  • enabled — bit(1) — NOT NULL

product_description

  • id — bigint(20) — 기본 키 — NOT NULL
  • product_id — bigint(20) — 외래 키 → product.id — NOT NULL
  • text — longtext — NOT NULL
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL

product_image

  • product_id — bigint(20) — 외래 키 → product.id — NOT NULL
  • file_id — bigint(20) — 외래 키 → file.id — NOT NULL

product_tag

  • product_id — bigint(20) — 외래 키 → product.id — NOT NULL
  • tag_id — bigint(20) — 외래 키 → tag.id — NOT NULL

review

  • id — bigint(20) — 기본 키 — NOT NULL
  • product_id — bigint(20) — 외래 키 → product.id — NOT NULL
  • user_id — bigint(20) — 외래 키 → user.id — NOT NULL
  • comment — longtext — NOT NULL
  • rating — int(11) — NOT NULL
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL

role

  • id — bigint(20) — 기본 키 — NOT NULL
  • authority — varchar(255) — NOT NULL

tag

  • id — bigint(20) — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • date_created — datetime — NOT NULL
  • tagged_count — int(11) — NOT NULL

user

  • id — bigint(20) — 기본 키 — NOT NULL
  • username — varchar(15) — NOT NULL
  • password — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • full_name — varchar(255) — NOT NULL
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL
  • enabled — bit(1) — NOT NULL
  • account_locked — bit(1) — NOT NULL

user_role

  • user_id — bigint(20) — 외래 키 → user.id — NOT NULL
  • role_id — bigint(20) — 외래 키 → role.id — NOT NULL