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)