chiken_factory
Tables (10)
Chicken Factories (Untitled2)
- chicken_factory_id (Key) — Primary key — NOT NULL
- stock_id (Key2) — Foreign key → Stocks.stock_id — NOT NULL
- term (Field)
- term_week (Field2)
- count (Field3)
Chickens (Untitled5)
- chkicken_id (Key) — Primary key — NOT NULL
- user_id (Key4) — Foreign key → Users.user_id — NOT NULL
- chicken_factory_id (Key2) — Foreign key → Chicken Factories.chicken_factory_id — NOT NULL
- stock_id (Key22) — Foreign key → Chicken Factories.stock_id — NOT NULL
- expired_at (Field)
- egg_count (Field2)
- created_at (Field3)
Eggs (Untitled8)
- egg_id (Key) — Primary key — NOT NULL
- chkicken_id (Key2) — Foreign key → Chickens.chkicken_id — NOT NULL
- user_id (Key4) — Foreign key → Chickens.user_id — NOT NULL
- chicken_factory_id (Key22) — Foreign key → Chickens.chicken_factory_id — NOT NULL
- stock_id (Key222) — Foreign key → Chickens.stock_id — NOT NULL
- value (Field)
- Field2
History (Untitled10)
- Key — Primary key — NOT NULL
Nests (Untitled9)
- Key — Primary key — NOT NULL
- balance (Field)
Spawn (Untitled4)
- day (string) — Foreign key → days_of_the_week.day — NOT NULL
- chicken_factory_id (Key2) — Foreign key → Chicken Factories.chicken_factory_id — NOT NULL
- stock_id (Key22) — Foreign key → Chicken Factories.stock_id — NOT NULL
Stocks (Untitled)
- stock_id (Key) — Primary key — NOT NULL
- Field
Transaction (Untitled7)
- transaction_id (Key) — Primary key — NOT NULL
- chicken_factory_id (Key2) — Foreign key → Chicken Factories.chicken_factory_id — NOT NULL
- stock_id (Key22) — Foreign key → Chicken Factories.stock_id — NOT NULL
- value_per_chicken (Field)
- Field2
Users (Untitled6)
- user_id (Key) — Primary key — NOT NULL
days_of_the_week (Untitled3)
- day (string) — Primary key — NOT NULL