Advertisement
Guest User

Untitled

a guest
Feb 13th, 2013
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.63 KB | None | 0 0
  1. == Table structure for table Plant
  2.  
  3. |------
  4. |Column|Type|Null|Default
  5. |------
  6. |//**Plant_ID**//|int(10)|No|
  7. |Plant_Quantity|int(3)|No|
  8. |Plant_Price|decimal(6,2)|No|
  9. |Plant_Description|text|No|
  10. |Plant_Latin_Name|varchar(50)|No|
  11. |Plant_Common_Name|varchar(50)|No|
  12. |Plant_Height|decimal(4,2)|No|
  13. |Plant_Spread|decimal(4,2)|No|
  14. |Plant_Type|varchar(20)|No|
  15. |Plant_Family|varchar(30)|No|
  16. |Plant_Picture|varchar(255)|No|
  17.  
  18. == Table structure for table Plant_Aspect
  19.  
  20. |------
  21. |Column|Type|Null|Default
  22. |------
  23. |//**Plant_ID**//|int(10)|No|
  24. |//**Plant_Aspect**//|varchar(12)|No|
  25.  
  26. == Table structure for table Plant_Flower_Colour
  27.  
  28. |------
  29. |Column|Type|Null|Default
  30. |------
  31. |//**Plant_ID**//|int(10)|No|
  32. |//**Plant_Flower_Colour**//|varchar(15)|No|
  33. |Plant_Season|varchar(7)|No|
  34.  
  35. == Table structure for table Plant_Foliage_Colour
  36.  
  37. |------
  38. |Column|Type|Null|Default
  39. |------
  40. |//**Plant_ID**//|int(10)|No|
  41. |//**Plant_Foliage_Colour**//|varchar(15)|No|
  42. |Plant_Season|varchar(7)|No|
  43.  
  44. == Table structure for table Plant_Moisture
  45.  
  46. |------
  47. |Column|Type|Null|Default
  48. |------
  49. |//**Plant_ID**//|int(10)|No|
  50. |//**Plant_Moisture**//|varchar(22)|No|
  51.  
  52. == Table structure for table Plant_Moisture
  53.  
  54. |------
  55. |Column|Type|Null|Default
  56. |------
  57. |//**Plant_ID**//|int(10)|No|
  58. |//**Plant_Soil_PH**//|varchar(8)|No|
  59.  
  60. == Table structure for table Plant_Soil_Type
  61.  
  62. |------
  63. |Column|Type|Null|Default
  64. |------
  65. |//**Plant_ID**//|int(10)|No|
  66. |//**Plant_Soil_Type**//|varchar(5)|No|
  67.  
  68. == Table structure for table Plant_Sun_Type
  69.  
  70. |------
  71. |Column|Type|Null|Default
  72. |------
  73. |//**Plant_ID**//|int(10)|No|
  74. |//**Plant_Sun_Type**//|varchar(13)|No|
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement