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