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