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