T-FDSA 021-2021 重大活动食品分类和毒害危险物质数据存储规范

T/FDSA

T/FDSA

文件定了大活食品类和害危物质据存的总技术明、食品类数存储

GB/T

GB/T

GB/T

3.1

major

3.2

4.1

SUBSTANCES_TAB

SURF_CHN_LIMIT_TAB

4.2

4.3

4.4

4.5

表1

表1

6.1

表2

6.2

食品添加剂/营养强化剂数据

ADDITIVE/NUTRIEN_TAB

ADDITIVE/NUTRIENT_USAGE

AGME_NUM_DISA_TOXIC

SUBSTANCES_TAB

T/FDSA

表3

表3

表4

表4

7.1

7.2

8.1

GB/T

8.2

8.3

8.4

8.5

CATEGORY_IDNUMBERCATEGORIESVARCHAR2NUMBERCATEGORIES

分区粒度/范围D_DATETIME

A.1

A.1

A.1

A.2A.3

A.3IDNUMBERVARCHAR2ENGLISH_GENERAL_NAMEVARCHAR2LATIN_NAMEVARCHAR2COMMODITY_NAMEVARCHAR2VARCHAR2OTHER_NAMEVARCHAR2

VARCHAR2VARCHAR2NUMBER10CHEMICAL_STRUCTUREVARCHAR211PHYSICAL_CHEMICAL_PROPERTIESVARCHAR211.1APPEARANCE_CHARACTERVARCHAR211.2BOILING_POINTVARCHAR211.3MELTING_POINTMVARCHAR211.4VARCHAR211.5VAPOR_PRESSUREVARCHAR211.6SOLUBILITYVARCHAR211.7RELATIVE_DENSITYVARCHAR211.8OCTANOL_MOISTUREVARCHAR212SOURCE_USEVARCHAR212.1VARCHAR212.2SOURCEVARCHAR213VARCHAR213.1

VARCHAR213.2ACUTE_TOXICITY_CLASSIFICATIONVARCHAR213.3OTHER_TOXICVARCHAR213.4

VARCHAR2T/FDSA

B.1

13.5VARCHAR213.6VARCHAR214

VARCHAR215VARCHAR216VARCHAR217VARCHAR218VARCHAR219COMBUSTION_DECOMPOSITION_PRODUCTVARCHAR220VARCHAR221EPIDEMIOLOGICAL_CHARACTERISTICVARCHAR222BIOLOGICAL_CHARACTERISTICSVARCHAR223POISONING_WAYVARCHAR224CLINICAL_SYMPVARCHAR225TOXICADVERSE_TOMSVARCHAR226PHARMACOLOGICAL_TOXICOLOGICAL_ACTIONVARCHAR227EPIDEMIOLOGICAL_CHARACTERISTICVARCHAR228LABOR_ABILIT_APPRAISALVARCHAR229VARCHAR230HUMAN_BODY_EFFECTSVARCHAR231CHRONIC_EFFECTSVARCHAR232DIAGNOSTIC_POINTVARCHAR233VARCHAR234SCENE_EMERGENCYVARCHAR235PROTECTIVE_MEASURESVARCHAR236DECONTAMINATION_METHODVARCHAR237AVOID_CONTACT_CONDITIONVARCHAR238METHOD_MECHANISM_ACTIONVARCHAR2

B.1

B.1

ENGLISH_GENERAL_NAME

LATIN_NAME

COMMODITY_NAME

OTHER_NAME

ID分区粒度/范围D_DATETIME

T/FDSA

B.2

B.2

B.3

IDNUMBERSUBSTANCE_NAMEVARCHAR2VARCHAR2DAA_FOOD_NAMESVARCHAR2MAXIMUM_LIMITSVARCHAR2NUMBERNOTEVARCHAR2IDSUBSTANCE_NAME

NOTED_DATETIME

月/分区T/FDSA

C.1

C.1

C.1

C.2 C.3

C.3 IDNUMBER添加剂/营养强化剂名称ADDITIVE/NUTRIENT_NAMEVARCHAR2VARCHAR2VARCHAR2

SOURCEVARCHAR2DAA_FOOD_NAMESVARCHAR2最大使用量/使用量VARCHAR2NUMBERNOTEVARCHAR2IDADDITIVE/NUTRIENT_NAME

DAA_FOOD_NAMESMAXIMUM_USAGE/USAG

NOTE分区粒度/范围D_DATETIME

T/FDSA

食品添加剂/营养强化剂使用量数据表D.1

D.1

D.1

D.2

D.2

D.3

T/FDSA