Research Article

[Retracted] Design and Application of Land Resource Management System Based on Internet of Things

Table 1

Scheme of one book four.

Field nameChinese nameData typeCan it be blankRemarks

Specification No.Instruction serial numbernvarhcarNoPrimary key
AssociatedNo.Item serial number associationnvarhcarNoForeign key
ResponsiblePersonPrincipalnvarhcarNoForeign key
Applicant NameName of applicantnvarhcarNo
Project NameEntry namenvarhcarNo
ProjectC/BNameProject county/city/batch namenvarhcarNo
AppITotalAreaTotal area of applied landnvarhcarYes
NewLand areaNew land areanvarhcarYes
TotalS ituationTotal current situation_totalnvarhcarYes
TotalCurrent SitOTotal current situation_state owned landnvarhcarYes
TotalCurrent SitCTotal current situation_collective landnvarhcarYes
TotalAgriculturalLandAgricultural land_totalnvarhcarYes
OwnedAgricuLandAgricultural land_state-ownednvarhcarYes
CollecAgricuLandAgricultural land_collectivenvarhcarYes
Total arable landCultivated land_totalnvarhcarYes
State-owned farmlandCultivated land_state-ownednvarhcarYes
CollectiveFarmlandCultivated land_collectivenvarhcarYes
TotalBasicFarmlandBasic farmland_totalnvarhcarYes
State-ownedFarmlandBasic farmland_state-ownednvarhcarYes
BasicFarmland _ collectiveBasic farmland_collectivenvarhcarYes
TotalWoodlandWoodland_totalnvarhcarYes
State-ownedForestWoodland_state-ownednvarhcarYes
Woodland _ collectiveWoodland_collectivenvarhcarYes
Total1Total 1nvarhcarYes
Total2Total 2nvarhcarYes
Total3Total 3nvarhcarYes
Owned1State-owned 1nvarhcarYes
Owned2State-owned 2nvarhcarYes
Owned3State-owned 3nvarhcarYes
Group1Collective 1nvarhcarYes
Group2Collective 2nvarhcarYes
Group3Collective 3nvarhcarYes
ConnAssoBounSurAssociation survey boundary connectionnvarhcarYes
AssodAddiLandCultivated land connectionnvarhcarYes
AssesAgenEvaluation authoritynvarhcarYes
EvaluReportNoAppraisal report nonvarhcarYes
ProjectAppTimeProject approval timenvarhcarYes
DesignAppTimeDesign approval timenvarhcarYes
ConstruFundsComposition of construction fundsnvarhcarYes
ProjectConsPeriodProject construction periodnvarhcarYes
AddLandWaySupplementary cultivated land modenvarhcarYesForeign key
RemarksRemarksnvarhcarYes