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)