mojang

Tables (29)

admin_user

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • email — varchar(255)
  • password — varchar(255)

blog

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • contents — varchar(255)
  • is_visible — bit(1)
  • sub_title — varchar(255)
  • tags — varchar(255)
  • thumbnail_url — varchar(255)
  • title — varchar(255)
  • views — int(11) — NOT NULL

cemetery

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • name — varchar(255)
  • funeral_id — bigint(20) — Foreign key → funeral.id

cemetery_level

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • name — varchar(255)
  • cemetery_id — bigint(20) — Foreign key → cemetery.id

cemetery_menu

  • id — bigint(20) — Primary key — NOT NULL
  • cemetery_level_id — bigint(20) — Foreign key → cemetery_level.id
  • funeral_menu_id — bigint(20) — Foreign key → funeral_menu.id

city

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(255)
  • state_id — bigint(20) — Foreign key → state.id

funeral

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • address — varchar(255)
  • address_detail — varchar(255)
  • x — double
  • y — double
  • contact — varchar(255)
  • contents — varchar(255)
  • label — varchar(255)
  • name — varchar(255)
  • thumbnail_url — varchar(255)
  • title — varchar(255)
  • city_id — bigint(20) — Foreign key → city.id
  • state_id — bigint(20) — Foreign key → state.id
  • funeral_type_id — bigint(20) — Foreign key → funeral_type.id

funeral_image

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • image_url — varchar(255)
  • funeral_id — bigint(20) — Foreign key → funeral.id

funeral_main_category

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • name — varchar(255)
  • funeral_id — bigint(20) — Foreign key → funeral.id

funeral_menu

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • introduction — varchar(255)
  • menu_type — varchar(255)
  • name — varchar(255)
  • price — int(11)
  • funeral_set_id — bigint(20) — Foreign key → funeral_set.id
  • funeral_id — bigint(20) — Foreign key → funeral.id
  • detail — varchar(255)

funeral_middle_category

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • introduction — varchar(255)
  • kind — varchar(255)
  • name — varchar(255)
  • price — int(11)
  • funeral_main_category_id — bigint(20) — Foreign key → funeral_main_category.id

funeral_set

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • name — varchar(255)
  • funeral_id — bigint(20) — Foreign key → funeral.id

funeral_type

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • name — varchar(255)

keyword

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • keyword — varchar(255)

menu

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • name — varchar(255)

menu_category

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • is_multiple — bit(1)
  • name — varchar(255)
  • menu_id — bigint(20) — Foreign key → menu.id

notice

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • contents — varchar(255)
  • is_visible — bit(1)
  • title — varchar(255)
  • views — int(11) — NOT NULL

notification

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • contents — varchar(255)
  • is_read — bit(1)
  • redirect_url — varchar(255)
  • user_id — bigint(20) — Foreign key → user_account.id
  • route — varchar(255)

notification_template

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • body — varchar(255)
  • notification_template_command — varchar(255)
  • route — varchar(255)
  • title — varchar(255)

opinion

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • entombment — varchar(255)
  • etc — varchar(255)
  • is_washing — bit(1)
  • mourner_count — int(11)
  • process — varchar(255)
  • shroud — varchar(255)
  • title — varchar(255)
  • uuid — varchar(255)
  • user_id — bigint(20) — Foreign key → user_account.id

product

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • introduction — varchar(255)
  • name — varchar(255)
  • price — varchar(255)
  • product_category_id — bigint(20) — Foreign key → menu_category.id

quotation

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • title — varchar(255)
  • total_price — int(11)
  • reservation_id — bigint(20) — Foreign key → reservation.id
  • cemetery — varchar(255)
  • cemetery_type — varchar(255)
  • memo — varchar(2000)
  • cemetery_level — varchar(255)

quotation_menu

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • introduction — varchar(255)
  • name — varchar(255)
  • price — int(11)
  • quotation_id — bigint(20) — Foreign key → quotation.id
  • funeral_menu_type — varchar(255)

reservation

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • canceled_at — datetime(6)
  • imp_uid — varchar(255)
  • pay_method — varchar(255)
  • payment_at — datetime(6)
  • tel — varchar(255)
  • reservation_state — varchar(255)
  • funeral_id — bigint(20) — Foreign key → funeral.id
  • funeral_set_id — bigint(20) — Foreign key → funeral_set.id
  • quotation_id — bigint(20) — Foreign key → quotation.id
  • user_id — bigint(20) — Foreign key → user_account.id
  • cemetery_level_id — bigint(20) — Foreign key → cemetery_level.id
  • mourner_count — int(11)
  • dispatch_state — int(11)
  • city_id — bigint(20) — Foreign key → city.id
  • opinion_id — bigint(20) — Foreign key → opinion.id
  • state_id — bigint(20) — Foreign key → state.id
  • v_bank_code — varchar(255)
  • v_bank_date — bigint(20)
  • v_bank_holder — varchar(255)
  • v_bank_issued_at — bigint(20)
  • v_bank_name — varchar(255)
  • v_bank_num — varchar(255)

reservation_history

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • reservation_state — varchar(255)
  • reservation_id — bigint(20) — Foreign key → reservation.id

review

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • contents — varchar(255)
  • point — double
  • funeral_id — bigint(20) — Foreign key → funeral.id
  • user_id — bigint(20) — Foreign key → user_account.id
  • reservaion_id — bigint(20) — Foreign key → reservation.id
  • admin_user_id — bigint(20) — Foreign key → admin_user.id

review_keyword

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • keyword_id — bigint(20) — Foreign key → keyword.id
  • review_id — bigint(20) — Foreign key → review.id

state

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(255)

user_account

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_user_id — bigint(20)
  • updated_at — datetime(6)
  • updated_user_id — bigint(20)
  • deleted_at — datetime(6)
  • is_deleted — bit(1)
  • birth — date
  • email — varchar(255)
  • gender — varchar(255)
  • last_login_at — datetime(6)
  • nickname — varchar(255)
  • password — varchar(255)
  • phone — varchar(255)
  • profile_url — varchar(255)
  • provider — varchar(255)
  • provider_id — varchar(255)
  • push_token — varchar(255)