grape
Tables (5)
Drone (drone)
- drone id (id) — INT — Primary key — NOT NULL
- is drone flying (is_fly) — BOOLEAN
- datetime to fly (start_time) — DATETIME
- drone name (product_name) — VARCHAR
- drone image (product_img) — VARCHAR
- section to fly (zone) — INT
- user id (user_id) — VARCHAR(100) — Foreign key → User.user id — NOT NULL
Each Grape (grape)
- each grape id (grape_id) — INT — Primary key — NOT NULL
- quality id (quality_id) — INT — Foreign key → Qulity.id — NOT NULL
- number of berries (berry) — INT
- grade of grape (grade) — CHAR
- number of rotten berry (sick_berry) — INT
- is thinning need (pruning) — BOOL
Fly_info (flight)
- id — INT — Foreign key → Drone.drone id — NOT NULL
- init x location (init_x) — INT
- init y location (init_y) — INT
- width of flight area (width) — INT
- length of flight area (height) — INT
- height of grape (grape_height) — INT
- grape interval (interval) — INT
- sight of drone video (sight_range) — INT
Qulity (quality)
- id — INT — Primary key — NOT NULL
- datetime video filmed (date) — DATETIME
- video file name (video) — VARCHAR
- drone id (drone_id) — INT — Foreign key → Drone.drone id — NOT NULL
- user id (user_id) — VARCHAR — Foreign key → User.user id — NOT NULL
User (user)
- user id (user_id) — INT — Primary key — NOT NULL
- passward (pw) — VARCHAR
- 별명 (name) — VARCHAR
- 이메일 (email) — VARCHAR