Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- == Table structure for table Plant
- |------
- |Column|Type|Null|Default
- |------
- |//**Plant_ID**//|int(10)|No|
- |Plant_Quantity|int(3)|No|
- |Plant_Price|decimal(6,2)|No|
- |Plant_Description|text|No|
- |Plant_Latin_Name|varchar(50)|No|
- |Plant_Common_Name|varchar(50)|No|
- |Plant_Height|decimal(4,2)|No|
- |Plant_Spread|decimal(4,2)|No|
- |Plant_Type|varchar(20)|No|
- |Plant_Family|varchar(30)|No|
- |Plant_Picture|varchar(255)|No|
- == Table structure for table Plant_Aspect
- |------
- |Column|Type|Null|Default
- |------
- |//**Plant_ID**//|int(10)|No|
- |//**Plant_Aspect**//|varchar(12)|No|
- == Table structure for table Plant_Flower_Colour
- |------
- |Column|Type|Null|Default
- |------
- |//**Plant_ID**//|int(10)|No|
- |//**Plant_Flower_Colour**//|varchar(15)|No|
- |Plant_Season|varchar(7)|No|
- == Table structure for table Plant_Foliage_Colour
- |------
- |Column|Type|Null|Default
- |------
- |//**Plant_ID**//|int(10)|No|
- |//**Plant_Foliage_Colour**//|varchar(15)|No|
- |Plant_Season|varchar(7)|No|
- == Table structure for table Plant_Moisture
- |------
- |Column|Type|Null|Default
- |------
- |//**Plant_ID**//|int(10)|No|
- |//**Plant_Moisture**//|varchar(22)|No|
- == Table structure for table Plant_Moisture
- |------
- |Column|Type|Null|Default
- |------
- |//**Plant_ID**//|int(10)|No|
- |//**Plant_Soil_PH**//|varchar(8)|No|
- == Table structure for table Plant_Soil_Type
- |------
- |Column|Type|Null|Default
- |------
- |//**Plant_ID**//|int(10)|No|
- |//**Plant_Soil_Type**//|varchar(5)|No|
- == Table structure for table Plant_Sun_Type
- |------
- |Column|Type|Null|Default
- |------
- |//**Plant_ID**//|int(10)|No|
- |//**Plant_Sun_Type**//|varchar(13)|No|
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement