Australian Nutrient

Module: australian-diet

Module Contents

  1. australian-nutrient


1CENTER_NOnumber (2,0)Required:false
Center identification number.

2PERSON_ID (*PK)number (12,0)Required:false
Number that uniquely identifies an individual. *PERSON_ID is the primary key for the table.

3PORTION_STANDARD_FACTORnumber (13,5)Required:false
Portion (standard) factor

4ENERGY_KJ_IN_FOODnumber (13,5)Required:false
Energy in food (kj/day)

5PROTEIN_IN_FOODnumber (13,5)Required:false
Protein in food (g/day)

6TOTAL_FAT_IN_FOODnumber (13,5)Required:false
Total fat in food (g/day)

7SATUR_FAT_IN_FOODnumber (13,5)Required:false
Saturated fat in food (g/day)

8MONOUNSAT_FAT_IN_FOODnumber (13,5)Required:false
Monounsaturated fat in food (g/day)

9POLYUNSAT_FAT_IN_FOODnumber (13,5)Required:false
Polyunsaturated fat in food (g/day)

10CHOLESTEROL_IN_FOODnumber (13,5)Required:false
Cholestero in foodl (mg/day)

11CARBOHYDRATE_IN_FOODnumber (13,5)Required:false
Carbohydrate in food (g/day)

12STARCH_IN_FOODnumber (13,5)Required:false
Starch in food (g/day)

13SUGARS_IN_FOODnumber (13,5)Required:false
Sugars in food (g/day)

14FIBRE_IN_FOODnumber (13,5)Required:false
Fibr in foode (g/day)

15CALCIUM_IN_FOODnumber (13,5)Required:false
Calcium in food (mg/day)

16BETA_CAROTENE_EQUIV_IN_FOODnumber (13,5)Required:false
Beta-Carotene Equivalent in food (ug/day)

17PHOSPHORUS_IN_FOODnumber (13,5)Required:false
Phosphurus in food (mg/day)

18MAGNESIUM_IN_FOODnumber (13,5)Required:false
Magnesium in food (mg/day)

19IRON_IN_FOODnumber (13,5)Required:false
Iron in food (mg/day)

20SODIUM_IN_FOODnumber (13,5)Required:false
Sodium in food (mg/day)

21POTASSIUM_IN_FOODnumber (13,5)Required:false
Potassium in food (mg/day)

22ZINC_IN_FOODnumber (13,5)Required:false
Zinc in food (mg/day)

23VITAMIN_C_IN_FOODnumber (13,5)Required:false
Vitamin C in food (mg/day)

24VITAMIN_E_IN_FOODnumber (13,5)Required:false
Vitamin E in food (mg/day)

25ALPHA_CAROTENE_IN_FOODnumber (13,5)Required:false
Alpha-Carotene in food (ug/day)

26BETA_CAROTENE_IN_FOODnumber (13,5)Required:false
Beta-Carotene in food (ug/day)

27BETA_CRYPTOXANTHIN_IN_FOODnumber (13,5)Required:false
Beta-Cryptoxanthin in food (ug/day)

28LYCOPENE_IN_FOODnumber (13,5)Required:false
Lycopene in food (ug/day)

29LUTEIN_ZEAXANTHIN_IN_FOODnumber (13,5)Required:false
Lutein Zeaxanthin in food (ug/day)

30THIAMIN_IN_FOODnumber (13,5)Required:false
Thiamin in food (mg/day)

31RIBOFLAVIN_IN_FOODnumber (13,5)Required:false
Riboflavin in food (mg/day)

32NIACIN_IN_FOODnumber (13,5)Required:false
Niacin in food (mg/day)

33NIACIN_EQUIV_IN_FOODnumber (13,5)Required:false
Niacin Equivalent in food (mg/day)

34FOLATE_IN_FOODnumber (13,5)Required:false
Folate in food (ug/day)

35RETINOL_IN_FOODnumber (13,5)Required:false
Retinol in food (ug/day)

36RETINOL_EQUIV_IN_FOODnumber (13,5)Required:false
Retinol Equivalent in food (ug/day)

37FD40number (13,5)Required:false
Fatty Acid – Butyric (g/day)

38FD60number (13,5)Required:false
Fatty Acid – Caproic (g/day)

39FD80number (13,5)Required:false
Fatty Acid – Capricylic (g/day)

40FD100number (13,5)Required:false
Fatty Acid – Capric (g/day)

41FD120number (13,5)Required:false
Fatty Acid – Lauric acid (g/day)

42FD140number (13,5)Required:false
Fatty Acid – Myristic (g/day)

43FD150number (13,5)Required:false
Fatty Acid – Pentadecanoic (g/day)

44FD160number (13,5)Required:false
Fatty Acid – Palmitic (g/day)

45FD170number (13,5)Required:false
Fatty Acid – Margaric (g/day)

46FD180number (13,5)Required:false
Fatty Acid – Stearic (g/day)

47FD200number (13,5)Required:false
Fatty Acid – Arachidic (g/day)

48FD220number (13,5)Required:false
Fatty Acid – Behenic (g/day)

49FD240number (13,5)Required:false
Fatty Acid – Lignoceric (g/day)

50FD141number (13,5)Required:false
Fatty Acid – Myristoleic (g/day)

51FD151number (13,5)Required:false
Fatty Acid – Pentadecenoic (g/day)

52FD161number (13,5)Required:false
Fatty Acid – Palmitoleic (g/day)

53FD171number (13,5)Required:false
Fatty Acid – Trans palmitoleic (g/day)

54FD181number (13,5)Required:false
Fatty Acid – Heptadecenoic (g/day)

55FD181Tnumber (13,5)Required:false
Fatty Acid – Oleic (g/day)

56FD201number (13,5)Required:false
Fatty Acid – Eicosenic (g/day)

57FD221number (13,5)Required:false
Fatty Acid – Erucic (g/day)

58FD182N6number (13,5)Required:false
Fatty Acid – Linoleic (g/day)

59FD182N6Tnumber (13,5)Required:false
Fatty Acid – Trans linoleic (g/day)

60FD183N3number (13,5)Required:false
Fatty Acid – Alpha-linoleic (g/day)

61FD202N6number (13,5)Required:false
Fatty Acid – Eicosadienoic (g/day)

62FD203N6number (13,5)Required:false
Fatty Acid – Dihomo-gammalinolenic (g/day)

63FD204N6number (13,5)Required:false
Fatty Acid – Arachidonic (g/day)

64FD205N3number (13,5)Required:false
Fatty Acid – Eicosapentaenoic (g/day)

65FD224N6number (13,5)Required:false
Fatty Acid – Adrenic (g/day)

66FD225N3number (13,5)Required:false
Fatty Acid – Clupanodonic (g/day)

67FD226N3number (13,5)Required:false
Fatty Acid – Decosahexaenoic (g/day)

68GLYCAEMIC_INDEXnumber (13,5)Required:false
The glycaemic index(GI) rates carbohydrates according to how quickly they raise the glucose level of the blood.

69GLYCAEMIC_LOADnumber (13,5)Required:false
The glycaemic load rates carbohydrates according to the glcaemic index and the amount of carbohydrate in the food.

70ENERGY_KJ_IN_ALCOHOLnumber (13,5)Required:false
Energy in alcohol (kj/day)

71PROTEIN_IN_ALCOHOLnumber (13,5)Required:false
Protein in alcohol (g/day)

72CARBOHYDRATES_IN_ALCOHOLnumber (13,5)Required:false
Carbohydrates in alcohol (g/day)

73SUGARS_IN_ALCOHOLnumber (13,5)Required:false
Sugars in alcohol (g/day)

74STARCH_IN_ALCOHOLnumber (13,5)Required:false
Starch in alcohol (g/day)

75TOTAL_ALCOHOLnumber (13,5)Required:false
Total alcohol (g/day)

76BETA_CAROTENE_IN_ALCOHOLnumber (13,5)Required:false
Beta-Carotene in alcohol (ug/day)

77CALCIUM_IN_ALCOHOLnumber (13,5)Required:false
Calcium in alcohol (mg/day)

78FOLATE_IN_ALCOHOLnumber (13,5)Required:false
Folate in alcohol (ug/day)

79IRON_IN_ALCOHOLnumber (13,5)Required:false
Iron in alcohol (mg/day)

80MAGNESIUM_IN_ALCOHOLnumber (13,5)Required:false
Magnesium in alcohol (mg/day)

81NIACIN_IN_ALCOHOLnumber (13,5)Required:false
Niacin in alcohol (mg/day)

82NIACIN_EQUIV_IN_ALCOHOLnumber (13,5)Required:false
Niacin equivalent in alcohol (mg/day)

83PHOSPHORUS_IN_ALCOHOLnumber (13,5)Required:false
Phosphorus in alcohol (mg/day)

84POTASSIUM_IN_ALCOHOLnumber (13,5)Required:false
Potassium in alcohol (mg/day)

85RIBOFLAVIN_IN_ALCOHOLnumber (13,5)Required:false
Riboflavin in alcohol (mg/day)

86SODIUM_IN_ALCOHOLnumber (13,5)Required:false
Sodium in alcohol (mg/day)

87VITAMIN_C_IN_ALCOHOLnumber (13,5)Required:false
Vitamin C in alcohol (mg/day)

88FULL_CREAM_MILKnumber (13,5)Required:false
Full cream milk (g/day)

89RED_FAT_MILKnumber (13,5)Required:false
Reducaed fat milk (g/day)

90SKIM_MILKnumber (13,5)Required:false
Skim milk (g/day)

91SOYA_MILKnumber (13,5)Required:false
Soya milk (g/day)

92HFIBRE_WHITE_BREADnumber (13,5)Required:false
High fibre white bread (g/day)

93WHITE_BREADnumber (13,5)Required:false
White bread (g/day)

94WHOLEMEALnumber (13,5)Required:false
Wholemeal bread (g/day)

95RYEnumber (13,5)Required:false
Rye bread (g/day)

96MULTI_GRAINnumber (13,5)Required:false
Multi grain bread (g/day)

97MARGARINEnumber (13,5)Required:false
Margarine (g/day)

98POLY_MARGARINEnumber (13,5)Required:false
Polyunsaturated margarine (g/day)

99MONO_MARGARINEnumber (13,5)Required:false
Monounsaturated margarine (g/day)

100BUTTER_MARG_BLENDSnumber (13,5)Required:false
Butter and margarine blends (g/day)

101BUTTER_MARG_BLENDSnumber (13,5)Required:false
Butter (g/day)

102HARD_CHEESEnumber (13,5)Required:false
Hard cheese (g/day)

103FIRM_CHEESEnumber (13,5)Required:false
Firm cheese (g/day)

104SOFT_CHEESEnumber (13,5)Required:false
Soft cheese (g/day)

105RICOTTA_COTTAGEnumber (13,5)Required:false
Ricotta or cottage cheese (g/day)

106CREAM_CHEESEnumber (13,5)Required:false
Cream cheese (g/day)

107LOW_FAT_CHEESEnumber (13,5)Required:false
Low fat cheese (g/day)

108SUGARnumber (13,5)Required:false
Sugar (g/day)

109EGGSnumber (13,5)Required:false
Eggs (g/day)

110ALLBRANnumber (13,5)Required:false
All Bran cereal (g/day)

111BRANFLAKESnumber (13,5)Required:false
Branflakes (g/day)

112WEETBIXnumber (13,5)Required:false
Weet-Bix (g/day)

113CORNFLAKESnumber (13,5)Required:false
Cornflakes (g/day)

114PORRIDGEnumber (13,5)Required:false
Porridge (g/day)

115MUESLInumber (13,5)Required:false
Muesli (g/day)

116RICEnumber (13,5)Required:false
Rice (g/day)

117PASTAnumber (13,5)Required:false
Pasta (g/day)

118CRACKERSnumber (13,5)Required:false
Crackers (g/day)

119SWEET_BISCUITnumber (13,5)Required:false
Sweet biscuits (g/day)

120CAKESnumber (13,5)Required:false
Cakes (g/day)

121MEAT_PIEnumber (13,5)Required:false
Meat pies (g/day)

122PIZZAnumber (13,5)Required:false
Pizza (g/day)

123HAMBURGERnumber (13,5)Required:false
Hamburger (g/day)

124CHOCOLATEnumber (13,5)Required:false
Chocolate (g/day)

125FLAVOURED_MILKnumber (13,5)Required:false
Flavoured milk drink (g/day)

126NUTSnumber (13,5)Required:false
Nuts (g/day)

127PEANUT_BUTTERnumber (13,5)Required:false
Peanut butter (g/day)

128CRISPSnumber (13,5)Required:false
Crisps (g/day)

129JAMnumber (13,5)Required:false
Jam (g/day)

130VEGEMITEnumber (13,5)Required:false
Vegemite (g/day)

131ICE_CREAMnumber (13,5)Required:false
Ice cream (g/day)

132YOGHURTnumber (13,5)Required:false
yoghurt (g/day)

133BEEFnumber (13,5)Required:false
Beef (g/day)

134VEALnumber (13,5)Required:false
Veal (g/day)

135CHICKENnumber (13,5)Required:false
Chicken (g/day)

136LAMBnumber (13,5)Required:false
Lamb (g/day)

137PORKnumber (13,5)Required:false
Pork (g/day)

138BACONnumber (13,5)Required:false
Bacon (g/day)

139HAMnumber (13,5)Required:false
Ham (g/day)

140SALAMInumber (13,5)Required:false
Salami (g/day)

141SAUSAGESnumber (13,5)Required:false
Sausages (g/day)

142FISHnumber (13,5)Required:false
Fish (g/day)

143FRIED_FISHnumber (13,5)Required:false
Fried fish (g/day)

144TINNED_FISHnumber (13,5)Required:false
Tinned fish (g/day)

145TINNED_FRUITnumber (13,5)Required:false
Tinned fruit (g/day)

146FRUIT_JUICEnumber (13,5)Required:false
Fruit juice (g/day)

147ORANGESnumber (13,5)Required:false
Oranges (g/day)

148APPLESnumber (13,5)Required:false
Apples (g/day)

149PEARSnumber (13,5)Required:false
Pears (g/day)

150BANANASnumber (13,5)Required:false
Bananas (g/day)

151MELONnumber (13,5)Required:false
Melon (g/day)

152PINEAPPLEnumber (13,5)Required:false
Pineapple (g/day)

153STRAWBERRIESnumber (13,5)Required:false
Strawberries (g/day)

154APRICOTSnumber (13,5)Required:false
Apricots (g/day)

155PEACHESnumber (13,5)Required:false
Peaches (g/day)

156MANGOnumber (13,5)Required:false
Mango (g/day)

157AVOCADOnumber (13,5)Required:false
Avocado (g/day)

158CHIPSnumber (13,5)Required:false
Chips (g/day)

159POTATOESnumber (13,5)Required:false
potatoes (g/day)

160TOMATO_SAUCEnumber (13,5)Required:false
Tomato sauce (g/day)

161TOMATOESnumber (13,5)Required:false
Tomatoes (g/day)

162CAPSICUMnumber (13,5)Required:false
Capsicum (g/day)

163LETTUCEnumber (13,5)Required:false
Lettuce (g/day)

164CUCUMBERnumber (13,5)Required:false
Cucumber (g/day)

165CELERYnumber (13,5)Required:false
Celery (g/day)

166BEETROOTnumber (13,5)Required:false
Beetroot (g/day)

167CARROTSnumber (13,5)Required:false
Carrots (g/day)

168CABBAGEnumber (13,5)Required:false
Cabbage (g/day)

169CAULIFLOWERnumber (13,5)Required:false
Cauliflower (g/day)

170BROCCOLInumber (13,5)Required:false
Broccoli (g/day)

171SPINACHnumber (13,5)Required:false
Spinach (g/day)

172PEASnumber (13,5)Required:false
Peas (g/day)

173GREEN_BEANSnumber (13,5)Required:false
Green beans (g/day)

174BEAN_SPROUTSnumber (13,5)Required:false
Bean sprouts (g/day)

175BAKED_BEANSnumber (13,5)Required:false
Baked beans (g/day)

176TOFUnumber (13,5)Required:false
Tofu (g/day)

177OTHER_BEANSnumber (13,5)Required:false
Other beans (g/day)

178PUMPKINnumber (13,5)Required:false
Pumpkin (g/day)

179ONIONnumber (13,5)Required:false
Onion (g/day)

180GARLICnumber (13,5)Required:false
Garlic (g/day)

181MUSHROOMSnumber (13,5)Required:false
Mushrooms (g/day)

182ZUCCHINInumber (13,5)Required:false
Zucchini (g/day)

183LIGHT_BEERnumber (13,5)Required:false
Light beer (g/day)

184HEAVY_BEERnumber (13,5)Required:false
Heavy beer (g/day)

185RED_WINEnumber (13,5)Required:false
Red wine (g/day)

186WHITE_WINEnumber (13,5)Required:false
White wine (g/day)

187FORTIFIED_WINESnumber (13,5)Required:false
Fortified wines (g/day)

188SPIRITSnumber (13,5)Required:false
Spirits (g/day)