ㄴ

Tables (13)

ADDRESS

  • ID — CHAR(36) — Primary key — NOT NULL
  • USER_ID — CHAR(36) — NOT NULL
  • TITLE — VARCHAR(100) — 집,회사,사무실
  • RECIPIENT — VARCHAR(100)
  • ADDRESS — TEXT
  • ADDRESS_DETAIL — TEXT
  • PHONE — VARCHAR(100)
  • REQUEST — TEXT — 문앞,부재시문앞,경비실,택배함,기타
  • IS_DEFAULT — TINYINT(1) — NOT NULL — 1: 기본배송지, 0: 기타
  • ACCESS_NO — VARCHAR(100) — 공동현관 출입번호
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

BASIC

  • ID — CHAR(36) — Primary key — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

CANCELLATIONS

  • ID — CHAR(36) — Primary key — NOT NULL
  • ORDERS_ID — CHAR(36) — NOT NULL
  • TYPE — ENUM('cancel', 'return', 'exchange') — NOT NULL — 주문취소,반품,교환
  • STATUS — ENUM('pending', 'complete') — 취소요청(대기), 처리완료
  • REASON — TEXT
  • REFUNDED_AMOUNT — INT — NOT NULL
  • IS_CONFIRMED — TINYINT(1) — NOT NULL — 0: 미승인, 1: 승인
  • IS_REFUND — TINYINT(1) — NOT NULL — 0: 대기, 1: 처리완료
  • ACCOUNT_NUMBER — VARCHAR(100)
  • BANK_NAME — VARCHAR(100)
  • DEPOSITOR — VARCHAR(100)
  • CANCELED_AT — TIMESTAMP
  • COMPLETED_AT — TIMESTAMP
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

CARTS

  • ID — CHAR(36) — Primary key — NOT NULL
  • PRODUCTS_ID — CHAR(36) — NOT NULL
  • USER_ID — CHAR(36) — NOT NULL
  • AMOUNT — INT — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

CATEGORIES

  • ID — CHAR(36) — Primary key — NOT NULL
  • CODE — VARCHAR(100) — NOT NULL
  • NAME — VARCHAR(100) — NOT NULL
  • SEQ — INT — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

FILES

  • ID — CHAR(36) — Primary key — NOT NULL
  • PARENT_TABLE — VARCHAR(100) — NOT NULL
  • PARENT_ID — VARCHAR(100) — NOT NULL
  • NAME — TEXT — NOT NULL
  • ORIGIN_NAME — TEXT — NOT NULL
  • PATH — TEXT — NOT NULL
  • SIZE — INT — NOT NULL
  • IS_MAIN — BOOLEAN — NOT NULL
  • SEQ — INT — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

ORDERS

  • ID — CHAR(36) — Primary key — NOT NULL
  • USER_ID — CHAR(36) — NOT NULL
  • TITLE — VARCHAR(100) — NOT NULL
  • TOTAL_QUANTITY — INT — NOT NULL
  • TOTAL_COUNT — INT — NOT NULL
  • TOTAL_PRICE — INT — NOT NULL
  • STATUS — ENUM('PENDING', 'PAID', 'SHIPPING', 'DELIVERED', 'CANCELLED') — NOT NULL — 결제대기, 결제완료, 배송중,배송완료,주문취소
  • ORDERED_AT — TIMESTAMP — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

ORDER_ITEMS

  • ID — CHAR(36) — Primary key — NOT NULL
  • ORDERS_ID — CHAR(36) — NOT NULL
  • PRODUCTS_ID — CHAR(36) — NOT NULL
  • QUANTITY — INT — NOT NULL
  • PRICE — INT — NOT NULL
  • AMOUNT — INT
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

PAYMENTS

  • ID — CHAR(36) — Primary key — NOT NULL
  • ORDERS_ID — CHAR(36) — NOT NULL
  • PAYMENT_METHOD — VARCHAR(100)
  • STATUS — ENUM('PENDING', 'PAID', 'REFUND') — NOT NULL
  • COMMENT — '결제대기,결제완료,환불' — 결제대기,결제완료,환불
  • PAID_AT — TIMESTAMP — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

PRODUCTS

  • ID — CHAR(36) — Primary key — NOT NULL
  • NAME — VARCHAR(100) — NOT NULL
  • CATEGORY — VARCHAR(100)
  • DESCRIPTION — VARCHAR(200)
  • CONTENT — TEXT
  • PRICE — INT — NOT NULL
  • STOCK — INT
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

SHIPMENTS

  • ID — CHAR(36) — Primary key — NOT NULL
  • ORDERS_ID — CHAR(36) — NOT NULL
  • ADDRESS_ID — CHAR(36) — NOT NULL
  • TRACKING_NO — VARCHAR(255)
  • SHIP_COMPANY — VARCHAR(255)
  • STATUS — ENUM('PENDING', 'START', 'SHIPPING', 'DELIVERED', 'CANCELLED') — NOT NULL — 배송준비중, 배송시작, 배송중, 배송완료, 주문취소
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

USER

  • ID — CHAR(36) — Primary key — NOT NULL
  • USERNAME — VARCHAR(100) — NOT NULL
  • PASSWORD — VARCHAR(100) — NOT NULL
  • NAME — VARCHAR(100) — NOT NULL
  • PHONE — VARCHAR(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL
  • ENABLED — INT — NOT NULL

USER_AUTH

  • ID — CHAR(36) — Primary key — NOT NULL
  • USERNAME — VARCHAR(100) — NOT NULL
  • AUTH — VARCHAR(100) — NOT NULL