rgrg
Tables (18)
chat_message
- id — bigint — Primary key — NOT NULL
- chat_room_id — bigint — Foreign key → chat_room.id — NOT NULL
- created_time — datetime(6)
- member_id — bigint — Foreign key → member.member_id — NOT NULL
- updated_time — datetime(6)
- content — varchar(500) — NOT NULL
chat_participant
- id — bigint — Primary key — NOT NULL
- chat_room_id — bigint — Foreign key → chat_room.id — NOT NULL
- created_time — datetime(6)
- member_id — bigint — Foreign key → member.member_id — NOT NULL
- updated_time — datetime(6)
chat_room
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6)
- updated_time — datetime(6)
- is_group_chat — varchar(255)
- name — varchar(255) — NOT NULL
comment
- comment_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- member_id — bigint — Foreign key → member.member_id
- question_id — bigint — Foreign key → question.question_id
- updated_at — datetime(6)
- content — varchar(255)
comment_like
- id — bigint — Primary key — NOT NULL
- comment_id — bigint — Foreign key → comment.comment_id
- liked_at — datetime(6)
- member_id — bigint — Foreign key → member.member_id
disease
- disease_id — bigint — Primary key — NOT NULL
- confidence — double
- created_at — datetime(6)
- member_id — bigint — Foreign key → member.member_id
- disease_info — varchar(255)
- environment — varchar(255)
- nutrition — varchar(255)
- result — varchar(255)
- watering — varchar(255)
member
- member_id — bigint — Primary key — NOT NULL
- email — varchar(255)
- password — varchar(255)
- profile_url — varchar(255)
- refresh_token — varchar(255)
- username — varchar(255)
- role — enum('ROLE_ADMIN','ROLE_USER')
member_my_plant_list
- member_member_id — bigint — Foreign key → member.member_id — NOT NULL
- my_plant_list_id — bigint — Foreign key → my_plant.id — NOT NULL
my_plant
- id — bigint — Primary key — NOT NULL
- last_watered_date — date
- recommend_tonic — bit(1) — NOT NULL
- member_member_id — bigint — Foreign key → member.member_id
- plant_id — bigint — Foreign key → plant.id
- description — varchar(255)
- image_url — varchar(255)
- name — varchar(255)
- fertilizing_cycle — int
- repotting_cycle — int
- water_cycle — int
my_plant_seq
- next_val — bigint
plant
- id — bigint — Primary key — NOT NULL
- fertilizing_cycle — int
- repotting_cycle — int
- water_cycle — int
- description — varchar(255)
- dstrb — varchar(255)
- family_kor_nm — varchar(255)
- frit_desc — varchar(255)
- genus_kor_nm — varchar(255)
- grw_evrnt_desc — varchar(255)
- img_url — varchar(255)
- leaf_desc — varchar(255)
- plant_gnrl_nm — varchar(255) — NOT NULL
- plant_pilbk_no — varchar(255)
- plant_specs_scnm — varchar(255)
- sz — varchar(255)
- flwr_desc — longtext
- shpe — longtext
- use_mthd_desc — longtext
plant_seq
- next_val — bigint
prescription
- id — bigint — Primary key — NOT NULL
- confidence — double
- created_at — datetime(6)
- disease_info — varchar(255)
- environment — varchar(255)
- nutrition — varchar(255)
- result — varchar(255)
- watering — varchar(255)
- member_member_id — bigint — Foreign key → member.member_id
question
- question_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- member_id — bigint — Foreign key → member.member_id
- updated_at — datetime(6)
- content — varchar(255)
- title — varchar(255)
question_image
- question_image_id — bigint — Primary key — NOT NULL
- question_id — bigint — Foreign key → question.question_id
- uploaded_at — datetime(6)
- image_url — varchar(255)
read_status
- id — bigint — Primary key — NOT NULL
- is_read — bit(1) — NOT NULL
- chat_message_id — bigint — Foreign key → chat_message.id — NOT NULL
- chat_room_id — bigint — Foreign key → chat_room.id — NOT NULL
- member_id — bigint — Foreign key → member.member_id — NOT NULL
trade_post
- trade_post_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- member_id — bigint — Foreign key → member.member_id
- price — bigint
- updated_at — datetime(6)
- description — varchar(255)
- item_name — varchar(255)
trade_post_image
- trade_post_image_id — bigint — Primary key — NOT NULL
- trade_post_id — bigint — Foreign key → trade_post.trade_post_id
- uploaded_at — datetime(6)
- image_url — varchar(255)