ㅅㅅㅅ
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)