test
Tables (23)
batch_job_execution
- JOB_EXECUTION_ID — bigint — Primary key — NOT NULL
- VERSION — bigint
- JOB_INSTANCE_ID — bigint — Foreign key → batch_job_instance.JOB_INSTANCE_ID — NOT NULL
- CREATE_TIME — datetime(6) — NOT NULL
- START_TIME — datetime(6)
- END_TIME — datetime(6)
- STATUS — varchar(10)
- EXIT_CODE — varchar(2500)
- EXIT_MESSAGE — varchar(2500)
- LAST_UPDATED — datetime(6)
- INDEX — `JOB_INST_EXEC_FK`(`JOB_INSTANCE_ID` ASC)
batch_job_execution_context
- JOB_EXECUTION_ID — bigint — Foreign key → batch_job_execution.JOB_EXECUTION_ID — NOT NULL
- SHORT_CONTEXT — varchar(2500) — NOT NULL
- SERIALIZED_CONTEXT — text
batch_job_execution_params
- JOB_EXECUTION_ID — bigint — Foreign key → batch_job_execution.JOB_EXECUTION_ID — NOT NULL
- PARAMETER_NAME — varchar(100) — NOT NULL
- PARAMETER_TYPE — varchar(100) — NOT NULL
- PARAMETER_VALUE — varchar(2500)
- IDENTIFYING — char(1) — NOT NULL
- INDEX — `JOB_EXEC_PARAMS_FK`(`JOB_EXECUTION_ID` ASC)
batch_job_execution_seq
- ID — bigint — NOT NULL
- UNIQUE_KEY — char(1) — NOT NULL
batch_job_instance
- JOB_INSTANCE_ID — bigint — Primary key — NOT NULL
- VERSION — bigint
- JOB_NAME — varchar(100) — NOT NULL
- JOB_KEY — varchar(32) — NOT NULL
batch_job_seq
- ID — bigint — NOT NULL
- UNIQUE_KEY — char(1) — NOT NULL
batch_step_execution
- STEP_EXECUTION_ID — bigint — Primary key — NOT NULL
- VERSION — bigint — NOT NULL
- STEP_NAME — varchar(100) — NOT NULL
- JOB_EXECUTION_ID — bigint — Foreign key → batch_job_execution.JOB_EXECUTION_ID — NOT NULL
- CREATE_TIME — datetime(6) — NOT NULL
- START_TIME — datetime(6)
- END_TIME — datetime(6)
- STATUS — varchar(10)
- COMMIT_COUNT — bigint
- READ_COUNT — bigint
- FILTER_COUNT — bigint
- WRITE_COUNT — bigint
- READ_SKIP_COUNT — bigint
- WRITE_SKIP_COUNT — bigint
- PROCESS_SKIP_COUNT — bigint
- ROLLBACK_COUNT — bigint
- EXIT_CODE — varchar(2500)
- EXIT_MESSAGE — varchar(2500)
- LAST_UPDATED — datetime(6)
- INDEX — `JOB_EXEC_STEP_FK`(`JOB_EXECUTION_ID` ASC)
batch_step_execution_context
- STEP_EXECUTION_ID — bigint — Foreign key → batch_step_execution.STEP_EXECUTION_ID — NOT NULL
- SHORT_CONTEXT — varchar(2500) — NOT NULL
- SERIALIZED_CONTEXT — text
batch_step_execution_seq
- ID — bigint — NOT NULL
- UNIQUE_KEY — char(1) — NOT NULL
points_history_entity
- id — bigint — Primary key — NOT NULL
- del — bit(1)
- points — int
- created_date — datetime(6) — NOT NULL — time create record at
- deleted_date — datetime(6) — time delete record at
- updated_date — datetime(6) — NOT NULL — time update record at
- user_id — bigint
- INDEX — `FKl2pprwg9mm4et9e8v3c7uabef`(`user_id` ASC)
reservation_date_entity
- reservation_interval — varchar(255) — Primary key — NOT NULL
- empty_tables — bit(1)
- reservation_count — bigint
- total_tables_reservation — bigint
tb_administrative_division
- id — bigint — Primary key — NOT NULL
- main_category_code — int
- main_category_name — varchar(255)
tb_app_version
- id — bigint — Primary key — NOT NULL
- del — bit(1)
- created_date — datetime(6) — NOT NULL — time create record at
- deleted_date — datetime(6) — time delete record at
- updated_date — datetime(6) — NOT NULL — time update record at
- type — varchar(255) — NOT NULL
- version — varchar(255) — NOT NULL
tb_area_marketing
- area_id — bigint — Foreign key → tb_administrative_division.id — NOT NULL
- marketing_id — bigint — NOT NULL
- INDEX — `FKnq8x4t1v5an3xnge6g1encyel`(`area_id` ASC)
- INDEX — `FK1bqqxxm8l1epcoqndq1sc7tsa`(`marketing_id` ASC)
tb_authentication
- id — varchar(128) — Primary key — NOT NULL
- del — bit(1)
- has_revoked — bit(1) — NOT NULL — mark token has revoked
- created_date — datetime(6) — NOT NULL — time create record at
- deleted_date — datetime(6) — time delete record at
- updated_date — datetime(6) — NOT NULL — time update record at
- user_id — bigint — NOT NULL — User id
- access_token — varchar(256) — NOT NULL
- refresh_token — varchar(256) — NOT NULL
tb_brand
- id — bigint — Primary key — NOT NULL
- area_zip — int
- del — bit(1)
- store_quantity — int
- administrative_division_id — bigint — Foreign key → tb_administrative_division.id
- created_date — datetime(6) — NOT NULL — time create record at
- deleted_date — datetime(6) — time delete record at
- updated_date — datetime(6) — NOT NULL — time update record at
- ceo_phone — varchar(30)
- company_phone — varchar(30)
- manager_phone — varchar(30)
- ceo_name — varchar(100)
- company_name — varchar(100)
- manager_name — varchar(100)
- name — varchar(100) — NOT NULL
- original_url_image — varchar(500)
- url_image — varchar(500)
- address_area — varchar(255)
- details_address — varchar(255)
- INDEX — `FKcvn8wr8kjh5611oxw42sgqlkg`(`administrative_division_id` ASC)
tb_cart
- id — bigint — Primary key — NOT NULL
- del — bit(1)
- total_price — int
- created_date — datetime(6) — NOT NULL — time create record at
- deleted_date — datetime(6) — time delete record at
- store_id — bigint
- table_id — bigint
- updated_date — datetime(6) — NOT NULL — time update record at
- user_id — bigint
- INDEX — `FKny3p02oafmvc1ar5txxnowifm`(`store_id` ASC)
- INDEX — `FKcu3h18rabpnrh17apd44jrnh6`(`table_id` ASC)
- INDEX — `FKcaa66dfjxgpe9l7wiwesn82v8`(`user_id` ASC)
tb_cart_details
- id — bigint — Primary key — NOT NULL
- del — bit(1)
- quantity — int — NOT NULL
- total_price — int — NOT NULL
- cart_id — bigint — Foreign key → tb_cart.id
- created_date — datetime(6) — NOT NULL — time create record at
- deleted_date — datetime(6) — time delete record at
- menu_id — bigint
- updated_date — datetime(6) — NOT NULL — time update record at
- INDEX — `FKc62rxrv33dy7441oiwl2wrvha`(`cart_id` ASC)
- INDEX — `FK1t2own87f5fk2kbq1gfge931c`(`menu_id` ASC)
tb_cart_details_options
- id — bigint — Primary key — NOT NULL
- del — bit(1)
- order — int
- cart_details_id — bigint — Foreign key → tb_cart_details.id
- created_date — datetime(6) — NOT NULL — time create record at
- deleted_date — datetime(6) — time delete record at
- updated_date — datetime(6) — NOT NULL — time update record at
- content — varchar(255)
- option_ids — varchar(255)
- INDEX — `FKpc73cjx4n3cqj5cu5mub9q0lc`(`cart_details_id` ASC)
tb_category_menu
- id — bigint — Primary key — NOT NULL
- del — bit(1)
- position — int
- brand_id — bigint — Foreign key → tb_brand.id
- created_date — datetime(6) — NOT NULL — time create record at
- deleted_date — datetime(6) — time delete record at
- main_category_id — bigint — Foreign key → tb_category_menu.id
- store_id — bigint
- updated_date — datetime(6) — NOT NULL — time update record at
- name — varchar(100) — NOT NULL
- type_menu — varchar(255)
- INDEX — `FK74rm7u95hvdu5w888nhfa5jdy`(`brand_id` ASC)
- INDEX — `FKgjpdwme7ro1r5jbsi6s96oikl`(`main_category_id` ASC)
- INDEX — `FKpnmwsb1a50o15tss7w60i6gw`(`store_id` ASC)
tb_code
- code — varchar(255) — Primary key — NOT NULL
- description — varchar(255)
- group_code — varchar(255) — Foreign key → tb_groupcode.group_code
- name — varchar(255)
- INDEX — `FKph9urfxm5155p2c6yvdljefog`(`group_code` ASC)
tb_groupcode
- group_code — varchar(255) — Primary key — NOT NULL
- group_code_name — varchar(255)
tb_machine
- id — bigint — Primary key — NOT NULL
- del — bit(1)
- table_number — int
- created_date — datetime(6) — NOT NULL — time create record at
- deleted_date — datetime(6) — time delete record at
- store_id — bigint
- table_id — bigint
- updated_date — datetime(6) — NOT NULL — time update record at
- machine_code — varchar(50)
- floor_name — varchar(255)
- machine_type — varchar(255) — Foreign key → tb_code.code
- password — varchar(255)
- INDEX — `TB_MACHINE_IX01`(`machine_code` ASC)
- INDEX — `FKsv2iitmyeas23gv2xa2xlh43o`(`machine_type` ASC)
- INDEX — `FK4u0x6cwy9vgiwpjroav1s9wa`(`store_id` ASC)