asdfas
Tables (15)
give (Untitled13)
- giveDetailCode (Key2) — INT — Foreign key → givedetail.giveDetailCode — NOT NULL
- materialCode (Key22) — INT — Foreign key → givedetail.materialCode — NOT NULL
- orderCode (Key23) — INT — Foreign key → wdOrder.orderCode — NOT NULL
- supplyCode (Key3) — INT — Foreign key → wdOrder.supplyCode — NOT NULL
- giveDate (Field) — DATE
- giveTime (Field2) — TIME
- giveTotalPrice (Field3) — INT
givedetail (Untitled12)
- giveDetailCode (Key) — INT — Primary key — NOT NULL
- materialCode (Key2) — INT — Foreign key → material.materialCode — NOT NULL
- giveQuantity (Field2) — INT
- expirationDate (Field3) — DATE
- expirationTime (Field4) — TIME
- givePerPrice (Field5) — INT
- Field6
make (Untitled6)
- menuCode (Key2) — Foreign key → menu.menuCode — NOT NULL
- materialCode (Key) — INT — Foreign key → material.materialCode — NOT NULL
- makeStep (Field2) — INT
- makeAmount (Field3) — INT
material (Untitled8)
- materialCode (Key) — INT — Primary key — NOT NULL
- materialName (Field) — VARCHAR
- materialCurrent (Field2) — INT
- materialExpiration (Field3) — INT
- materialStartDate (Field4) — DATE
- mateiralEndDate (Field5) — DATE
materialinventorymanagement (Untitled9)
- mimCode (Key) — INT — Primary key — NOT NULL
- materialCode (Key2) — INT — Foreign key → material.materialCode — NOT NULL
- imaterialCode (Field) — INT
- materialWhenCurrent (Field3) — INT
- materialDate (Field4) — DATE
- materialTime (Field5) — TIME
- materialReason (Field6) — VARCHAR
- materialChange (Field2) — INT
materialmanagement (Untitled10)
- materialPriceCode (Key) — INT — Primary key — NOT NULL
- materialCode (Key2) — INT — Foreign key → material.materialCode — NOT NULL
- materialPrice (Field) — INT
- materialPriceStartDate (Field2) — DATE
- materialPriceEndDate (Field3) — DATE
menu (Untitled5)
- menuCode (Key) — Primary key — NOT NULL
- menuType (Field) — VARCHAR
- menuName (Field2) — VARCHAR
- menuStartDate (Field3) — DATE
- menuEndDate (Field4) — DATE
menupricemanagement (Untitled7)
- menuPriceCode (Key) — INT — Primary key — NOT NULL
- menuCode (Key2) — Foreign key → menu.menuCode — NOT NULL
- menuPrice (Field2) — INT
- menuPriceStartDate (Field3) — DATE
- menuPriceEndDate (Field4) — DATE
sell (Untitled4)
- sellCode (Key) — INT — Primary key — NOT NULL
- sbranchCode (Field) — INT
- suerCode (Field2) — INT
- sellDate (Field3) — DATE
- sellTime (Field4) — TIME
- sellTotal (Field5) — INT
- sellDayCode (Field6) — INT
sellbasket (Untitled2)
- menuBasketNum (Key) — INT — Primary key — NOT NULL
- menuCode (Field) — INT
- menuType (Field2) — VARCHAR
- menuName (Field3) — VARCHAR
- menuPrice (Field4) — VARCHAR
- menuAmount (Field5) — INT
selldetail (Untitled3)
- selldetailCode (Key) — INT — Primary key — NOT NULL
- userCode (Key2) — INT — Foreign key → user.userCode — NOT NULL
- menuBasketNum (Key3) — INT — Foreign key → sellbasket.menuBasketNum — NOT NULL
- sellCode (Key4) — INT — Foreign key → sell.sellCode — NOT NULL
- menuCode (Key5) — Foreign key → menu.menuCode — NOT NULL
- menuQuantity (Field4) — INT
- sellPerPrice (Field5) — INT
supply (Untitled11)
- supplyCode (Key) — INT — Primary key — NOT NULL
- supplyName (Field) — VARCHAR
- supplyTel (Field2) — VARCHAR
- supplyAdderss (Field3) — VARCHAR
- supplyCoperate (Field4) — VARCHAR
- supplyStartDate (Field5) — DATE
- supplyEndDate (Field6) — DATE
user (Untitled)
- userCode (Key) — INT — Primary key — NOT NULL
- userId (Field) — VARCHAR
- userPassword (Field2) — VARCHAR
- userName (Field3) — VARCHAR
- userBirth (Field4) — DATE
- userSex (Field5) — VARCHAR
- userAddress (Field6) — VARCHAR
- userTel (Field7) — VARCHAR
- userState (Field8) — VARCHAR
- userDate (Field9) — DATE
- userTime (Field10) — TIME
wdOrder (Untitled14)
- orderCode (Key2) — INT — Primary key — NOT NULL
- supplyCode (Key) — INT — Foreign key → supply.supplyCode — NOT NULL
- orderDate (Field) — DATE
- orderTime (Field2) — TIME
- orderTotal (Field3) — INT
wdorderdetail (Untitled15)
- orderDetailCode (Key) — INT — Primary key — NOT NULL
- orderCode (Key2) — INT — Foreign key → wdOrder.orderCode — NOT NULL
- supplyCode (Key3) — INT — Foreign key → wdOrder.supplyCode — NOT NULL
- omaterialCode (Field) — INT
- orderQuantity (Field2) — INT
- pricePerMaterial (Field3)