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