pj-manazoo

Tables (12)

AnimalIncomeExpend (Untitled2)

  • Key (aie_id) — varchar(6) — Primary key — NOT NULL
  • Key (Animal ID) — varchar(6) — Foreign key → Untitled.Key — NOT NULL
  • Key (InExId) — varchar(6) — Foreign key → IncomeExpend.Key — NOT NULL
  • Field

AnimalZooKeeper (Untitled3)

  • AZ ID (az_id) — varchar — Primary key — NOT NULL
  • Key (Animal ID) — varchar(6) — Foreign key → Untitled.Key — NOT NULL
  • Key (ZooKeeper ID) — varchar(6) — Foreign key → Untitled.Key — NOT NULL
  • Field

Copy Of Untitled (Visitor)

  • Key (Visitor Id) — varChar — Primary key — NOT NULL
  • Field (Name) — varchar(20)
  • Field (Phone) — varchar
  • Field (Date) — Date
  • Field (Adult Count) — Integer
  • Field (Child Count) — Integer
  • Field (Total Price) — Integer

EnclosureIncomeExpend (Untitled5)

  • Key (EIEId) — Integer — Primary key — NOT NULL
  • Key (Enclosure ID) — varchar(6) — Foreign key → Untitled.Key — NOT NULL
  • Key (InExId) — varchar(6) — Foreign key → IncomeExpend.Key — NOT NULL
  • Field

EnclosureZooKeeper (Untitled4)

  • Key (EZ ID) — varchar — Primary key — NOT NULL
  • Key (ZooKeeper ID) — varchar(6) — Foreign key → Untitled.Key — NOT NULL
  • Key (Enclosure ID) — varchar(6) — Foreign key → Untitled.Key — NOT NULL
  • Field

Finance

  • Key (Finance Id) — integer — Primary key — NOT NULL
  • Field (Capital) — Integer
  • Field (IncomeExpendRepository)

IncomeExpend

  • Key (InExId) — varchar(6) — Primary key — NOT NULL
  • Key (Finance Id2) — integer — Foreign key → Finance.Key — NOT NULL
  • Field (Money) — Integer
  • Field (IEType) — enum
  • Field (EventType) — enum
  • Field (desc) — varchar

Untitled (Enclosure)

  • Key (Enclosure ID) — varchar(6) — Primary key — NOT NULL
  • Field (Name) — varchar(20)
  • Field (Area SIze) — float
  • Field (Temperature) — float
  • Field (LocationType) — enum
  • Field (MaxCapacity) — integer

Untitled (Animal)

  • Key (Animal ID) — varchar(6) — Primary key — NOT NULL
  • Key (Enclosure ID) — varchar(6) — Foreign key → Untitled.Key — NOT NULL
  • Field (Name) — varchar(20)
  • Field (Species) — enum
  • Field (Age) — integer
  • Field (Gender) — enum
  • Field (HealthStatus) — varchar(10)

Untitled (ZooKeeper)

  • Key (ZooKeeper ID) — varchar(6) — Primary key — NOT NULL
  • Field (Name) — varchar(20)
  • Field (Age) — integer
  • Field (Genderge) — enum
  • Field (Rank) — enum
  • Field (Department) — enum
  • Field (IsWorking) — TINYINT
  • Field (Experience Year) — Integer
  • Field (canHandleDangeAnimal) — TinyInt
  • Field (Licenses) — varChar

Untitled (Reservation)

  • Key (Reservation Id) — varChar — Primary key — NOT NULL
  • Key (Visitor Id) — varChar — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (InExId) — varchar(6) — Foreign key → IncomeExpend.Key — NOT NULL
  • Field (Name) — varchar(20)
  • Field (Phone) — varchar
  • Field (Date) — Date
  • Field (Adult Count) — Integer
  • Field (Child Count) — Integer
  • Field (Total Price) — Integer

ZooKeeperIncomeExpend (Untitled)

  • Key (zkie_id) — varchar(6) — Primary key — NOT NULL
  • Key (ZooKeeper ID) — varchar(6) — Foreign key → Untitled.Key — NOT NULL
  • Key (InExId) — varchar(6) — Foreign key → IncomeExpend.Key — NOT NULL
  • Field