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)