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)