plantrow

Tables (7)

follow (Untitled6)

  • follower_id (Key) — bigint — Foreign key → user.id — NOT NULL
  • following_id (Field) — bigint — NOT NULL
  • createdate (Field2) — datetime — NOT NULL

peed (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • memo (Field) — varchar(255)
  • plike (Field2) — bigint
  • view (Field3) — bigint
  • createdate (Field4) — datetime — NOT NULL
  • updatedate (Field5) — datetime — NOT NULL

peed_img (Untitled5)

  • peed_id (Key) — bigint — Foreign key → peed.id — NOT NULL
  • img (Field) — varchar(20) — NOT NULL

plant (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • name (Field) — varchar(20) — NOT NULL
  • img (Field14) — varchar(20)
  • water (Field2) — int — NOT NULL
  • nutrients (Field3) — int — NOT NULL
  • division (Field4) — int — NOT NULL
  • water_update (Field5) — datetime — NOT NULL
  • nutrients_update (Field6) — datetime — NOT NULL
  • division_update (Field7) — datetime — NOT NULL
  • sunshine_mount (Field8) — int — NOT NULL
  • water_mount (Field9) — int — NOT NULL
  • temp_low (Field10) — int — NOT NULL
  • temp_high (Field11) — int — NOT NULL
  • createdate (Field12) — datetime — NOT NULL
  • updatedate (Field13) — datetime — NOT NULL

role (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • authority (Field) — varchar(10) — NOT NULL

user (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • username (Field) — varchar(10) — NOT NULL
  • name (Field2) — varchar(20) — NOT NULL
  • password (Field3) — varchar(100) — NOT NULL
  • email (Field4) — varchar(50)
  • phone (Field5) — varchar(15)
  • createdate (Field6) — datetime — NOT NULL

user_role (Untitled3)

  • user_id (Key) — bigint — Foreign key → user.id — NOT NULL
  • role_id (Key2) — int — Foreign key → role.id — NOT NULL