네이버스마트스토어

테이블 (15)

Account (회원)

  • account_id (Key) — long — 기본 키 — NOT NULL
  • username (Field) — varchar
  • password (Field2) — varchar
  • account_type (Field3) — varchar
  • email (Field4) — varchar
  • contact (Field5) — varchar
  • created_date (Field7) — datetime
  • modified_date (Field8) — datetime
  • status (Field9) — varchar
  • created_by (Field10) — long
  • modified_by (Field6) — long

Basetime (시간)

  • cretated_date (Field) — datetime
  • modified_date (Field2) — datetime

Category (카테고리)

  • category_id (Key) — long — 기본 키 — NOT NULL
  • upper_category_id (Key2) — long — 외래 키 → Category.category_id — NOT NULL
  • category_name (Field2) — varchar
  • type (Field) — long
  • status (Field3) — varchar
  • cretated_date (Field4) — datetime
  • modified_date (Field5) — datetime
  • created_by (Field6) — long
  • modified_by (Field7) — long

Client (고객)

  • client_id (Key) — long — 기본 키 — NOT NULL
  • delivery_address (Field) — varchar
  • account_id (Key2) — long — 외래 키 → Account.account_id — NOT NULL

Coupon (쿠폰)

  • coupon_id (Key) — long — 기본 키 — NOT NULL
  • coupon_name (Field) — varchar
  • type (Field2) — varchar
  • discount (Field3) — long
  • created_date (Field4) — datetime
  • modified_date (Field5) — datetime
  • created_by (Field6) — long
  • modified_by (Field7) — long
  • seller_id (Key2) — long — 외래 키 → Seller.seller_id — NOT NULL

Goods (상품)

  • goods_id (Key) — long — 기본 키 — NOT NULL
  • name (Field) — varchar
  • description (Field2) — varchar
  • status (Field4) — varchar
  • goods_status (Field8) — varchar
  • price (Field9) — long
  • maker (Field10) — varchar
  • brand (Field11) — varchar
  • representive_image (Key2) — long — 외래 키 → files.files_id — NOT NULL
  • category_id (Key3) — long — 외래 키 → Category.category_id — NOT NULL
  • created_date (Field3) — datetime
  • modified_date (Field5) — datetime
  • created_by (Field6) — long
  • modified_by (Field7) — long
  • seller_id (Key4) — long — 외래 키 → Seller.seller_id — NOT NULL

Options (옵션)

  • option_id (Key) — long — 기본 키 — NOT NULL
  • name (Field3) — varchar
  • option_setting_id (Key2) — long — 외래 키 → Options_setting.option_setting_id — NOT NULL

Options_item (옵션 값)

  • option_item_id (Key) — long — 기본 키 — NOT NULL
  • value (Field2) — varchar
  • option_id (Key2) — long — 외래 키 → Options.option_id — NOT NULL

Options_lists (옵션 리스트)

  • option_list_id (Key) — long — 기본 키 — NOT NULL
  • price (Field) — long
  • stock (Field2) — long
  • option_item_id1 (Key3) — long — 외래 키 → Options_item.option_item_id — NOT NULL
  • option_item_id2 (Key4) — long — 외래 키 → Options_item.option_item_id — NOT NULL
  • option_item_id3 (Key5) — long — 외래 키 → Options_item.option_item_id — NOT NULL

Options_setting (옵션 세팅)

  • option_setting_id (Key) — long — 기본 키 — NOT NULL
  • type (Field) — varchar
  • size (Field2) — varchar
  • sort (Field3) — varchar
  • stock (Field4) — long
  • goods_id (Key2) — long — 외래 키 → Goods.goods_id — NOT NULL

Orders (주문)

  • order_id (Key) — long — 기본 키 — NOT NULL
  • payment_type (Field) — varchar
  • delivery_address (Field2) — varchar
  • order_status (Field3) — varchar
  • created_date (Field4) — datetime
  • modified_date (Field5) — datetime
  • created_by (Field6) — long
  • modified_by (Field7) — long
  • client_id (Key2) — long — 외래 키 → Client.client_id — NOT NULL

Orders_item (주문상품)

  • order_item_id (Key2) — long — 기본 키 — NOT NULL
  • order_id (Key) — long — 외래 키 → Orders.order_id — NOT NULL
  • price (Field) — long
  • status (Field2) — varchar
  • name (Field3) — varchar
  • description (Field8) — varchar
  • goods_id (Key3) — long — 외래 키 → Goods.goods_id — NOT NULL
  • created_date (Field4) — datetime
  • modified_date (Field5) — datetime
  • created_by (Field6) — long
  • modified_by (Field7) — long

Seller (판매자)

  • seller_id (Key) — long — 기본 키 — NOT NULL
  • account_id (Key2) — varchar — 외래 키 → Account.account_id — NOT NULL
  • return_address (Field) — varchar
  • business_address (Field2) — varchar
  • created_date (Field3) — datetime
  • modified_date (Field4) — datetime
  • created_by (Field5) — long
  • modified_by (Field6) — long

admin (관리자)

  • admin_id (Key) — varchar — 기본 키 — NOT NULL
  • account_id (Key2) — varchar — 외래 키 → Account.account_id — NOT NULL
  • Field6
  • created_date (Field) — datetime
  • modified_date (Field2) — datetime
  • created_by (Field3) — long
  • modified_by (Field4) — long

files (파일)

  • files_id (Key) — long — 기본 키 — NOT NULL
  • size (Field) — long
  • extension (Field2) — varchar
  • original_name (Field3) — varchar
  • file_path (Field4) — varchar
  • status (Field5) — varchar
  • created_date (Field6) — datetime
  • modified_date (Field7) — datetime
  • created_by (Field8) — long
  • modified_by (Field9) — long