test
Tables (6)
Comment
- id — int — Primary key — NOT NULL
- created_at — datetime
- contents — varchar(500)
- post_Seq — int — NOT NULL
- user_Seq — int — NOT NULL
data
- Seq — VARCHAR(255) — Primary key — NOT NULL
- created_at — datetime
- temperature — double
- humidity — double
- pot_Seq — int — NOT NULL
post
- Seq — int — Primary key — NOT NULL
- created_at — int
- modified_at — int
- title — int
- content — int
- user_Seq — int — NOT NULL
- image_path — int
- Number_of_comments — int
- Number_of_thumbsup — int
- id — int — Foreign key → Comment.id — NOT NULL
- Field
pot
- Seq — int — Primary key — NOT NULL
- Field — VARCHAR(255)
- name — varchar((20)
- user_Seq — int — NOT NULL
- image_path — varchar(30)
- id — int — Foreign key → Comment.id — NOT NULL
- Seq (Seq2) — int — Foreign key → water_data.Seq — NOT NULL
- Seq (Seq3) — VARCHAR(255) — Foreign key → data.Seq — NOT NULL
- Field2
- Field3
user
- Seq — int — Primary key — NOT NULL
- name — varchar(20)
- id — varchar(10)
- pw — varchar(20)
- nickname — varchar(20)
- phone — varchar(20)
- image_path — varchar(100)
- profile_text — text
- created_at — datetime
- modified_at — datetime
- role — varchar(10)
- id (id2) — int — Foreign key → Comment.id — NOT NULL
- Seq (Seq2) — int — Foreign key → post.Seq — NOT NULL
water_data
- Seq — int — Primary key — NOT NULL
- created_at — datetime
- pot_Seq — int — NOT NULL