Bill
Tables (5)
Bill (계산서)
- id (ID) — Integer — Primary key — NOT NULL
- storeId (스토어ID) — Integer — Foreign key → Store.id — NOT NULL
- transactionDate (거래날짜) — datetime
- memo (메모) — varchar
- createdAt (생성날짜) — datetime
- updatedAt (수정날짜) — datetime
Category (카테고리)
- id (ID) — Integer — Primary key — NOT NULL
- name (이름) — varchar
- level (레벨) — Integer
- createdAt (생성날짜) — datetime
- updatedAt (수정날짜) — datetime
- parentCategoryId (부모 카테고리 ID) — Integer — Foreign key → Category.id — NOT NULL
OrderProduct (주문상품)
- id (ID) — Integer — Primary key — NOT NULL
- billId (계산서ID) — Integer — Foreign key → Bill.id — NOT NULL
- productId (상품ID) — Integer — Foreign key → Product.id — NOT NULL
- count (갯수) — Integer
- orderPrice (주문금액) — Integer
- transactionDate (거래날짜) — datetime
- createdAt (생성날짜) — datetime
- updatedAt (수정날짜) — datetime
Product (상품)
- id (ID) — Integer — Primary key — NOT NULL
- categoryId (카테고리ID) — Integer — Foreign key → Category.id — NOT NULL
- name (상품이름) — varchar
- price (가격) — Integer
- createdAt (생성날짜) — datetime
- updatedAt (수정날짜) — datetime
Store (스토어)
- id (ID) — Integer — Primary key — NOT NULL
- name (이름) — varchar
- businessNumber (사업자번호) — Integer
- owner (소유자 이름) — varchar
- address (사업자 주소) — varchar
- createdAt (생성날짜) — datetime
- updatedAt (수정날짜) — datetime