plant-i
Tables (14)
chatbot_result
- id — int — Primary key
- user_id — INT — Foreign key → users.user_id — NOT NULL
- user_message — varchar(100) — NOT NULL
- image — varchar(512) — NOT NULL
- result — varchar(1000) — NOT NULL
comment
- no — int(11) — Primary key — NOT NULL
- post_id — int(11) — Foreign key → post.no — NOT NULL
- user_id — int — Foreign key → users.id — NOT NULL
- content — varchar(512) — NOT NULL
- RegDate — datetime — NOT NULL
- UpdateDate — datetime
mbtiresult
- mbti — varchar(50) — Primary key — NOT NULL
- feature — varchar(1024)
- recommend — varchar(1024) — NOT NULL
- image — varchar(1024) — NOT NULL
plant
- p_id — int — Primary key — NOT NULL
- pName — varchar(50) — NOT NULL
- plantType — varchar(10) — NOT NULL
- plantCharacter — varchar(2000) — NOT NULL
- water_period — varchar(50) — NOT NULL
- flowering_time — varchar(50) — NOT NULL
- temperature — varchar(50) — NOT NULL
- humidity — varchar(50) — NOT NULL
- sunshine — varchar(50) — NOT NULL
- floriography — varchar(100)
- child — varchar(20) — NOT NULL
- manageability — varchar(50) — NOT NULL
- purpose — varchar(50) — NOT NULL
- size — varchar(50) — NOT NULL
- form — varchar(50) — NOT NULL
- MBTI — varchar(50) — NOT NULL
- image — varchar(1024) — NOT NULL
planticonimage
- no — int(11) — Primary key — NOT NULL
- plantType — varchar(10) — NOT NULL
- plantIconImage — varchar(512) — NOT NULL
post
- no — int(11) — Primary key — NOT NULL
- id — int — Foreign key → users.id — NOT NULL
- categoryt_id — int — Foreign key → post_category.categoryt_id — NOT NULL
- writer — varchar(15) — NOT NULL
- title — varchar(25) — NOT NULL
- content — text — NOT NULL
- image — text
- regDate — datetime — NOT NULL
- updateDate — datetime
- hits — int(5) — NOT NULL
post_category
- categoryt_id — int — Primary key — NOT NULL
- category — varchar(50) — NOT NULL
profileimage
- no — int(11) — Primary key — NOT NULL
- image — varchar(512) — NOT NULL
tag
- no — int(11) — Primary key — NOT NULL
- tag_name — varchar(20)
user_place
- no — int(11) — Primary key — NOT NULL
- place — varchar(20) — NOT NULL
- image — varchar(512) — NOT NULL
userfavorite
- no — int(11) — Primary key — NOT NULL
- id — int — Foreign key → users.id — NOT NULL
- p_id — int — Foreign key → plant.p_id — NOT NULL
- isliked — varchar(50) — NOT NULL
userlocation
- no — int(11) — Primary key — NOT NULL
- id — int — Foreign key → users.id — NOT NULL
- lat — varchar(512) — NOT NULL
- lon — varchar(512) — NOT NULL
userplant
- no — int(11) — Primary key — NOT NULL
- id — int — Foreign key → users.id — NOT NULL
- p_id — int — Foreign key → plant.p_id — NOT NULL
- pNname — varchar(30) — NOT NULL
- plant_date — date — NOT NULL
- last_watered — date — NOT NULL
- watering_time — date
- place — varchar(30) — NOT NULL
- image — varchar(512)
users
- id — int — Primary key — NOT NULL
- user_id — char(10) — NOT NULL
- Ptype — varchar(20)
- pw — char(20) — NOT NULL
- name — char(10) — NOT NULL
- Phone — varchar(11) — NOT NULL
- Nname — varchar(50) — NOT NULL
- image — varchar(512)
- RegDate — date — NOT NULL
- fcm_token — varchar(255)