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