ㄴ
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