farming

Tables (13)

chat

  • chat_id — bigint
  • python_session_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL

diaries

  • diary_id — bigint — Primary key
  • diary_date — date — NOT NULL
  • fertilized — bit — NOT NULL
  • pruned — bit — NOT NULL
  • watered — bit — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • dairy_image_file_id — bigint
  • updated_at — datetime(6) — NOT NULL
  • user_id — bigint — NOT NULL
  • content — text
  • title — varchar(255) — NOT NULL

diary_user_plant

  • diary_user_plant_id — bigint — Primary key
  • diary_id — bigint — NOT NULL
  • user_plant_id — bigint — NOT NULL

farm_info

  • farm_id — bigint — Primary key
  • available — bit
  • created_at — date
  • garden_unique_id — int — NOT NULL
  • latitude — double
  • longitude — double
  • updated_at — date
  • farm_image_file_id — bigint — NOT NULL
  • contact — varchar(255)
  • facilities — varchar(255)
  • farm_name — varchar(255)
  • lot_number_address — varchar(255)
  • operator — varchar(255)
  • road_name_address — varchar(255)

image_files

  • domain_id — bigint — NOT NULL
  • image_file_id — bigint
  • image_url — varchar(512) — NOT NULL
  • original_image_name — varchar(255)
  • s3key — varchar(255)
  • domain_type — enum — NOT NULL

notice

  • is_sent — bit — NOT NULL
  • created_at — datetime(6)
  • notice_id — bigint
  • sent_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(255) — NOT NULL
  • title — varchar(255) — NOT NULL

notification

  • is_read — bit — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • notification_id — bigint
  • user_id — bigint — NOT NULL
  • message — text
  • title — varchar(255) — NOT NULL

photo_analysis

  • created_at — datetime(6)
  • photo_analysis_id — bigint
  • photo_image_file_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • analysis_summary — text
  • detected_disease — varchar(255)
  • solution — text

plant_info

  • plant_id — bigint — Primary key
  • created_at — date
  • updated_at — date
  • plant_image_file_id — bigint — NOT NULL
  • plant_english_name — varchar(255)
  • plant_name — varchar(255) — NOT NULL
  • season — varchar(255)
  • species — varchar(255)

refresh_token

  • created_at — datetime(6) — NOT NULL
  • expires_at — datetime(6) — NOT NULL
  • id — bigint
  • user_pk — bigint — NOT NULL
  • refresh_token — varchar(512) — NOT NULL

subscription

  • subscription_id — bigint — Primary key
  • end_date — datetime(6)
  • start_date — datetime(6)
  • user_id — bigint — NOT NULL
  • status — varchar(20) — NOT NULL

user_plants

  • user_plant_id — bigint — Primary key
  • created_at — datetime(6)
  • farm_id — bigint — NOT NULL
  • plant_id — bigint — NOT NULL
  • planted_date — datetime(6)
  • updated_at — datetime(6)
  • user_id — bigint — NOT NULL
  • user_plant_image_file_id — bigint — NOT NULL
  • plant_nickname — varchar(20) — NOT NULL
  • notes — text
  • plant_name — varchar(255)
  • planting_place — varchar(255)

users

  • user_id — bigint — Primary key
  • profile_image_file_id — bigint
  • oauth_provider — varchar(20)
  • subscription_status — varchar(20) — NOT NULL
  • nickname — varchar(50) — NOT NULL
  • fcm_token — varchar(512)
  • email — varchar(255) — NOT NULL
  • oauth_id — varchar(255)
  • password — varchar(255) — NOT NULL
  • role — enum — NOT NULL