CompanyManager

Tables (10)

Auth (Untitled)

  • ID (Key2) — Primary key — NOT NULL
  • nickname (Field)
  • CreateAT (Field2)

BuyList (Untitled8)

  • ID (Key6) — Primary key — NOT NULL
  • ContentType (Key8) — Primary key — NOT NULL
  • ID (Key7) — Foreign key → Trade.ID — NOT NULL
  • ID (Key) — Foreign key → Trade.ID — NOT NULL
  • AuthId (Key222) — Foreign key → Trade.AuthId — NOT NULL
  • ID (Key2) — Foreign key → Trade.ID — NOT NULL
  • id (Key3) — Foreign key → Trade.id — NOT NULL
  • BuyDate (Field)
  • BuyQuantity (Field2)
  • Contents (Field3)
  • CreateAT (Field4)
  • MotifyAT (Field5)
  • buyprice (Field6)

Company (Untitled4)

  • ID (Key) — Foreign key → User.ID — NOT NULL
  • AuthId (Key22) — Foreign key → User.AuthId — NOT NULL
  • ID (Key2) — Foreign key → CompanyInfo.ID — NOT NULL
  • CompanyDetail (Field)
  • Comapny_Location (Field4)

CompanyInfo (Untitled9)

  • ID (Key2) — Primary key — NOT NULL
  • companyName (Field)
  • companyNumber (Field2)
  • createAt (Field3)

Product (Untitled6)

  • ID (Key) — Foreign key → Company.ID — NOT NULL
  • AuthId (Key222) — Foreign key → Company.AuthId — NOT NULL
  • ID (Key2) — Foreign key → Company.ID — NOT NULL
  • id (Key3) — Foreign key → ProductInfo.id — NOT NULL

ProductInfo (Untitled10)

  • id (Key) — Primary key — NOT NULL
  • productNumber (Field)
  • productName (Field2)
  • stock (Field3)
  • productPrice (Field4)
  • createAT (Field5)
  • IMAGE (Field6)

SalesList (Untitled7)

  • ID (Key6) — Primary key — NOT NULL
  • ContentType (Key8) — Primary key — NOT NULL
  • ID (Key7) — Foreign key → Trade.ID — NOT NULL
  • ID (Key) — Foreign key → Trade.ID — NOT NULL
  • AuthId (Key222) — Foreign key → Trade.AuthId — NOT NULL
  • ID (Key2) — Foreign key → Trade.ID — NOT NULL
  • id (Key3) — Foreign key → Trade.id — NOT NULL
  • SalesDate (Field)
  • SalesQuantity (Field2)
  • Contents (Field3)
  • CreateAT (Field4)
  • MotifyAT (Field5)
  • salesprice (Field6)

TotalList (Untitled3)

  • ID (Key8) — Primary key — NOT NULL
  • ContentType (Key9) — Primary key — NOT NULL
  • ID (Key7) — Foreign key → Trade.ID — NOT NULL
  • ID (Key) — Foreign key → Trade.ID — NOT NULL
  • AuthId (Key222) — Foreign key → Trade.AuthId — NOT NULL
  • ID (Key2) — Foreign key → Trade.ID — NOT NULL
  • id (Key3) — Foreign key → Trade.id — NOT NULL
  • TotalFee (Field)
  • Contents (Field2)
  • CreateAT (Field3)
  • MotifyAT (Field4)

Trade (Untitled2)

  • ID (Key7) — Primary key — NOT NULL
  • ID (Key) — Foreign key → Product.ID — NOT NULL
  • AuthId (Key222) — Foreign key → Product.AuthId — NOT NULL
  • ID (Key2) — Foreign key → Product.ID — NOT NULL
  • id (Key3) — Foreign key → Product.id — NOT NULL

User (Untitled5)

  • ID (Key) — Primary key — NOT NULL
  • AuthId (Key22) — Foreign key → Auth.ID — NOT NULL
  • CreateAT (Field2)
  • userType (Field)