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