T/SDBDA 13-2021 Active Group standards

T/SDBDA 13-2021 The specification for database design of agricultural technology extension information application demonstration platform

Publish Date: 2021-04-09 Implement Date: 2021-04-09 For services related to genuine standard inquiry, procurement, translation, and other related services in China, please Contact Us

Price: $ 20.00

Out of stock

Basic Information

Standard Code: T/SDBDA 13-2021

Standard Type: Group standards

Standard Status: Active

is_force_gb: no

CCS Name: Computer applications

ICS Name: Integrated Information Technology (IT)

Publish Date: 2021-04-09

Implement Date: 2021-04-09

Scope

Main Technical Content: 4 Table Design Principles The database tables of the Shandong Agricultural Technology Promotion Information Application Demonstration Platform organize data into two categories: a) Frequently accessed data (e.g., promotion technologies, agricultural early warning, etc.); b) Frequently modified data (e.g., service frequency, service area, number of service households, etc.). According to the actual needs and characteristics of the application, the data tables are classified as follows: a) Basic Data Tables: Describing the basic information of agricultural technology promotion entities, such as basic information of agricultural technology promotion institutions, basic conditions, and basic information of agricultural technology promotion personnel; b) System Management Tables: Storing parameters related to the operation of the agricultural technology promotion system and the control of agricultural technology promotion business, including roles, user information, permissions, user configuration information, and user login logs in the agricultural technology promotion integrated service platform; c) Data Dictionary Tables: Describing the list values of attributes, such as the titles and statuses of agricultural technology experts. 5 Main Table Structure Design Principles The Shandong Agricultural Technology Promotion Information Application Demonstration Platform includes main data tables such as the Farmer Information Table, Expert Information Table, Article Category Table, Article Table, Interactive Communication Table, Course Table, Class Table, Resource Table, Schedule Table, Notification Table, Student Table, Teacher Table, Homework Table, and Exercise Table. - The Farmer Information Table needs to describe attributes such as name, industry, scale, and identity. - The Expert Information Table needs to describe basic information such as name, specialty, profile picture, title, birth date, email, contact phone number,