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)