nodeshop
Tables (13)
Category (카테고리)
- id (Key) — Primary key — NOT NULL
- parent_id (Key2) — bigint(20)unsigned — Foreign key → Category.id — NOT NULL
- name (Field) — varchar(255)
- order (Field2) — int
- created_at (Field3) — datetime
- updated_at (Field4) — datetime
Checkout (결제)
- id (Key) — bigint(20)unsigned — Primary key — NOT NULL
- order_id (Key2) — bigint(20)unsigned — Foreign key → Order.id — NOT NULL
- imp_uid (Field) — varchar(255)
- merchant_uid (Field2) — varchar(255)
- paid_amount (Field3) — int(11)
- apply_num (Field4) — varchar(255)
- buyer_email (Field5) — varchar(255)
- buyer_name (Field6) — varchar(255)
- buyer_tel (Field7) — varchar(255)
- buyer_addr (Field8) — varchar(255)
- buyer_postcode (Field9) — varchar(255)
- status (Field10) — varchar(255)
- song_jang (Field11) — varchar(255)
- created_at (Field12) — datetime
- updated_at (Field13) — datetime
EmailKey (이메일 인증키)
- id (Key) — bigint(20)unsigned — Primary key — NOT NULL
- user_id (Key2) — bigint(20)unsigned — Foreign key → User.id — NOT NULL
- hash_key (Field) — varchar(200)
- created_at (Field2) — datetime
- updated_at (Field3) — datetime
LikesProducts (제품 좋아요)
- user_id (Key2) — bigint(20)unsigned — Foreign key → User.id — NOT NULL
- produt_id (Key3) — bigint(20)unsigned — Foreign key → Products.id — NOT NULL
- created_at (Field2) — datetime
- updated_at (Field3) — datetime
Order (주문)
- id (Key) — bigint(20)unsigned — Primary key — NOT NULL
- user_id (Key3) — bigint(20)unsigned — Foreign key → User.id — NOT NULL
- product_id (Key2) — bigint(20)unsigned — Foreign key → Products.id — NOT NULL
- order_number (Field) — varchar(20)
- payment_type (Field7) — varchar(50) — 결제방식
- email (Field2) — varchar(50) — 비회원확인
- status (Field3) — varchar(200) — 결제상태(결제완료/배송중/배송완료/구매확정)
- song_jang (Field4) — varchar(255) — 송장번호
- created_at (Field5) — datetime
- updated_at (Field6) — datetime
- confirmed_at (Field8) — datetime — 구매확정일
Products (제품)
- id (Key) — bigint(20)unsigned — Primary key — NOT NULL
- category_id (Key3) — bigint(20)unsigned — Foreign key → Category.id — NOT NULL
- user_id (Key2) — bigint(20)unsigned — Foreign key → User.id — NOT NULL
- product_code (Field7) — varchar(50)
- name (Field) — varchar(50)
- thumbnail (Field2) — varchar(100)
- price (Field3) — int(11)
- description (Field4) — varchar(1000)
- expired (Field8) — bit(1) — 상품만료
- created_at (Field5) — datetime
- updated_at (Field6) — datetime
ProductsMemo (제품 댓글)
- id (Key) — bigint(20)unsigned — Primary key — NOT NULL
- product_id (Key2) — bigint(20) — Foreign key → Products.id — NOT NULL
- content (Field) — text
- created_at (Field2) — datetime
- updated_at (Field3) — datetime
Qna (Untitled)
- id (Key) — bigint(20) — Primary key — NOT NULL
- parent_id (Field) — bigint(20)
- content (Field2) — varchar(100)
- created_at (Field3) — datetime
- updated_at (Field4) — datetime
- product_id (Key2) — bigint(20)unsigned — Foreign key → Products.id — NOT NULL
- user_id (Key3) — bigint(20)unsigned — Foreign key → User.id — NOT NULL
Review (리뷰)
- id (Key) — bigint(20)unsigned — Primary key — NOT NULL
- order_id (Key2) — bigint(20)unsigned — Foreign key → Order.id — NOT NULL
- product_id (Key4) — bigint(20)unsigned — Foreign key → Products.id — NOT NULL
- user_id (Key3) — bigint(20)unsigned — Foreign key → User.id — NOT NULL
- content (Field) — text
- score (Field2) — int — 평점
- created_at (Field3) — datetime
- updated_at (Field4) — datetime
Sale (할인)
- id (Key) — bigint(20)unsigned — Primary key — NOT NULL
- product_id (Key2) — bigint(20)unsigned — Foreign key → Products.id — NOT NULL
- start_date (Field) — datetime
- end_date (Field2) — datetime
- discount_rate (Field3) — int — 할인률
- created_at (Field4) — datetime
- updated_at (Field5) — datetime
Tag (태그)
- id (Key) — bigint(20)unsigned — Primary key — NOT NULL
- name (Field) — varchar(200)
- created_at (Field2) — datetime
- updated_at (Field3) — datetime
TagProduct (제품 태그)
- tag_id (Key) — bigint(20)unsigned — Foreign key → Tag.id — NOT NULL
- product_id (Key2) — bigint(20) — Foreign key → Products.id — NOT NULL
User (회원)
- id (Key) — bigint(20)unsigned — Primary key — NOT NULL
- username (Field) — varchar(255)
- password (Field2) — varchar(255)
- displayname (Field3) — varchar(255)
- status (Field4) — varchar(255)
- created_at (Field5) — datetime
- updated_at (Field6) — datetime
- expired_at (Field7) — datetime