농장
테이블 (9)
FarmInformation
- FarmID — SERIAL
- LivestockBusinessRegNumber — VARCHAR(50)
- AgriculturalManagementEntityNumber — VARCHAR(50)
- LivestockType — VARCHAR(50)
- FarmName — VARCHAR(100)
- FarmOwnerName — VARCHAR(100)
- FarmAddress — VARCHAR(200)
- ContactInformation — VARCHAR(50)
FarmLocationInformation
- ReferenceLocation — VARCHAR(200)
- AbsoluteLocation — VARCHAR(200)
- LocationData — VARCHAR(200)
FarrowingCrateInformation
- FarrowingCrateID — SERIAL
- PigRoomID — INT
- FarrowingCrateName — VARCHAR(100)
- FarrowingCrateArea — FLOAT
FeedingFacilityInformation
- FeedingFacilityID — SERIAL
- PigHouseID — INT
- FeedBinInformation — VARCHAR(200)
- FeedInformation — VARCHAR(200)
PigHouseInformation
- PigHouseID — SERIAL
- FarmID — INT
- PigHouseName — VARCHAR(100)
- PigHouseLocation — VARCHAR(200)
- PigHouseSize — FLOAT
- PigHouseCondition — VARCHAR(50)
- RoofType — VARCHAR(50)
- SolarPanelInstallationStatus — BOOLEAN
PigPenInformation
- PigPenID — SERIAL
- PigRoomID — INT
- PigPenName — VARCHAR(100)
- PigPenSize — FLOAT
PigRoomInformation
- PigRoomID — SERIAL
- PigHouseID — INT
- PigRoomName — VARCHAR(100)
- PigRoomSize — FLOAT
- StanchionInstallationStatus — BOOLEAN
StallInformation
- StallID — SERIAL
- PigPenID — INT
- StallName — VARCHAR(100)
- StallArea — FLOAT
WateringFacilityInformation
- WateringFacilityID — SERIAL
- PigHouseID — INT
- WaterCapacity — FLOAT
- WateringMethod — VARCHAR(100)