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