네이버스마트스토어
테이블 (10)
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
Category (카테고리)
- category_id (Key) — long — 기본 키 — NOT NULL
- upper_category_id (Field) — long
- category_name (Field2) — varchar
- 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
- 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
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_date (Field9) — long