MILY

Tables (10)

Estimate (Untitled8)

  • id (Key2) — bitint(20) — Primary key — NOT NULL
  • mily_user_id (Key4) — bigint(20) — Foreign key → MilyUser.id — NOT NULL
  • first_category_id (Key) — bigint(20) — Foreign key → FirstCategory.id — NOT NULL
  • second_category_id (Key3) — bigint(20) — Foreign key → SecondCategory.id — NOT NULL
  • area (Field) — varchar(255)
  • body (Field2) — varchar(255)
  • create_date (Field3) — datetime(6)

Feed (Untitle)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • author_id (Key23) — bigint(20) — Foreign key → LawyerUser.mily_user_id — NOT NULL
  • create_date (Field3) — datetime(6)
  • modify_date (Field4) — datetime(6)
  • subject (Field) — varchar(255)
  • body (Field6) — varchar(255)
  • adopt (Field10) — tinyint(1)
  • view (Field2) — int(11)
  • vote (Field5) — int(11)
  • has_vote (Field7) — tinyint(1)

FirstCategory (Untitled4)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • second_category_id (Field3) — int(11) — Primary key
  • milyx_id (Field2) — int(11) — Foreign key → MilyX.first_category_id
  • title (Field) — varchar(255)

LawyerUser (Untitled2)

  • mily_user_id (Key2) — bigint(20) — Foreign key → MilyUser.id — NOT NULL
  • major (Field) — varchar(255) — NOT NULL
  • area (Field2) — varchar(255) — NOT NULL
  • office_address (Field3) — varchar(255) — NOT NULL
  • introduce (Field4) — varchar(255) — NOT NULL
  • license_number (Field5) — varchar(255) — NOT NULL
  • profile_img_file_path (Field6) — varchar(255) — NOT NULL

MilyUser (Untitled)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • user_create_date (Field) — datetime(6)
  • user_login_id (Field2) — varchar(255)
  • user_password — varchar(255)
  • user_email (Field3) — varchar(255) — NOT NULL
  • user_phone_number (Field4) — varchar(255)
  • user_date_of_birth (Field5) — varchar(255)
  • mily_point (Field6) — int(11) — NOT NULL
  • role (Field7) — varchar(255) — NOT NULL

MilyX (Untitled3)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • first_category_id (Field) — int(11) — Primary key
  • second_category_id (Field2) — int(11) — Primary key
  • author_id (Key2) — bigint(20) — Foreign key → MilyUser.id — NOT NULL
  • create_date (Field3) — datetime(6)
  • modify_date (Field4) — datetime(6)
  • subject (Field5) — varchar(255)
  • body (Field6) — varchar(255)
  • mily_point (Field7) — int(11)
  • view (Field9) — int(11)
  • has_adopted_answer (Field10) — tinyint(1)
  • MilyXComment (Field11)

MilyXComment (undefined)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • milyx_id (Key2) — bigint(20) — Foreign key → MilyX.id — NOT NULL
  • author_id (Key23) — bigint(20) — Foreign key → LawyerUser.mily_user_id — NOT NULL
  • create_date (Field3) — datetime(6)
  • modify_date (Field4) — datetime(6)
  • body (Field6) — varchar(255)
  • adopt (Field10) — tinyint(1)

Payment (Untitled6)

  • id (Key) — bitint(20) — Primary key — NOT NULL
  • mily_user_id (Key2) — bigint(20) — Foreign key → MilyUser.id — NOT NULL
  • order_id (Field) — varchar(255)
  • order_name (Field2) — varchar(255)
  • order_date (Field3) — datetime(6)
  • mily_point (Field4) — int(11)
  • amount (Field5) — bigint(20)

Reservation (Untitled7)

  • id (Key3) — bitint(20) — Primary key — NOT NULL
  • mily_user_id (Key) — bigint(20) — Foreign key → MilyUser.id — NOT NULL
  • lawyer_user_id (Key2) — bigint(20) — Foreign key → LawyerUser.mily_user_id — NOT NULL
  • reservation_time (Field) — datetime(6)

SecondCategory (Untitled5)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • milyx_id (Key2) — bigint(20) — Foreign key → MilyX.id — NOT NULL
  • first_category_id (Field2) — int(11) — Foreign key → FirstCategory.milyx_id
  • title (Field) — varchar(255)