ㅅㅅㅅ

Tables (13)

ClientInquiry (고객사 문의)

  • clientInquiryId (Key) — Primary key — NOT NULL
  • motherCode (Field)
  • classificationCode (Field2)
  • title (Field3)
  • content (Field4)
  • createdAt (Field5)
  • answerContent (Field6)
  • answerStatus (Field7)
  • answerAt (Field8)

ClientOrder (고객사 발주)

  • clientOrderId (Key) — Primary key — NOT NULL
  • motherCode (Field6)
  • classficationCode (Field)
  • productCode (Field2)
  • orderMount (Field3)
  • createdAt (Field4)
  • deliveryAt (Field5)
  • modifiedYN (Field7)
  • modifiedAt (Field8)

Device (기기)

  • deviceId (Key) — Primary key — NOT NULL
  • supplierCode (Field)
  • deviceType (Field2)
  • deviceCode (Field3)
  • manager (Field4)
  • phone (Field5)
  • email (Field6)
  • createdAt (Field7)

DiscardHistory (폐기 이력)

  • discardHistoryId (Key) — Primary key — NOT NULL
  • supplierCode (Field)
  • clientCode (Field2)
  • productCode (Field3)
  • productsSerialCode (Field4)
  • rfidChipCode (Field5)
  • discardAt (Field6)
  • reason (Field7)

Faq (FAQ)

  • faqId (Key) — Primary key — NOT NULL
  • classificationCode (Field)
  • question (Field2)
  • answer (Field3)
  • createdAt (Field4)

Order (발주)

  • orderId (Key) — Primary key — NOT NULL
  • classficationCode (Field)
  • productCode (Field2)
  • orderMount (Field3)
  • createdAt (Field4)
  • deliveryAt (Field5)

OrderInquiry (주문 문의)

  • orderInquiryId (Key) — Primary key — NOT NULL
  • classificationCode (Field)
  • title (Field2)
  • content (Field3)
  • createdAt (Field4)

Product (상품)

  • productId (Key) — Primary key — NOT NULL
  • productCode (Field)
  • productName (Field2)
  • purchasePrice (Field3)
  • productImg (Field4)
  • status (Field6)
  • createdAt (Field5)

ProductDetail (식기 상세 이력 정보)

  • productDetailId (Key) — Primary key — NOT NULL
  • rfidChipCode (Field)
  • productsSerialCode (Field2)
  • productCode (Field3)
  • supplierCode (Field4)
  • clientCode (Field8)
  • status (Field5)
  • cycle (Field6)
  • latestReadingAt (Field7)

ProductDetailHistory (식기 상세 심화 이력 정보)

  • productDetailHistoryId (Key) — Primary key — NOT NULL
  • rfidChipCode (Field)
  • productsSerialCode (Field2)
  • productCode (Field3)
  • supplierCode (Field4)
  • clientCode (Field8)
  • status (Field5)
  • cycle (Field6)
  • latestReadingAt (Field7)

Recall (반품)

  • recallId (Key) — Primary key — NOT NULL
  • classficationCode (Field)
  • productCode (Field2)
  • recallMount (Field3)
  • createdAt (Field4)
  • possibleRecallAt (Field5)

SupplyProduct (공급사 상품)

  • supplyProductId (Key) — Primary key — NOT NULL
  • productId (Key2) — Foreign key → Product.productId — NOT NULL
  • rentalPrice (Field)
  • maximumOrderMount (Field2)
  • classificationCode (Field3)

member (회원)

  • memberId (Key) — Primary key — NOT NULL
  • grade (Field)
  • motherCode (Field2)
  • classificationCode (Field3)
  • loginId (Field4)
  • password (Field5)
  • clientCompany (Field7)
  • address (Field6)
  • represent (Field8)
  • businessNumber (Field9)
  • stateOfBusiness (Field10)
  • categoryBusiness (Field11)
  • bankName (Field12)
  • bankAccountNumber (Field13)
  • bankAccountName (Field14)
  • manager (Field15)
  • phone (Field16)
  • position (Field17)
  • email (Field18)
  • etc (Field19) — c
  • createdAt (Field20)
  • withDrawal (Field21)
  • withDrawalDate (Field22)