농장

테이블 (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)