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)