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