WorkersHigh
Tables (50)
_tb_branch_product_temp
- client_name — varchar(30) — NOT NULL
- client_code — varchar(30) — NOT NULL
- minibar_nickname — varchar(30)
- minibar_code — varchar(30)
- product_name — varchar(50) — NOT NULL
- product_code — varchar(30) — NOT NULL
- quantity — int(11) — NOT NULL
- standard_quantity — int(11) — NOT NULL
- sell_count — int(11) — NOT NULL
- price — int(11) — NOT NULL
_tb_category_update
- id — int(11)
- barcode — varchar(18)
- product_name — varchar(50)
- category_name — varchar(50)
_tb_excel_import
- __id — int(11) — Primary key — NOT NULL
- ex_location_name — varchar(50)
- ex_barcode — varchar(50)
- ex_product_name — varchar(50)
- ex_quantity — int(11)
- ex_expiry_date — varchar(50)
_tb_list
- id — int(11) — Primary key — NOT NULL
- product_name — varchar(50)
- barcode — varchar(18)
- stock — int(11)
- proper_stock — int(11)
- branch_price — int(11)
_tb_minibar_stock_temp
- minibar_code — varchar(50)
- product_code — varchar(50)
- quantity — int(11)
- standard_quantity — int(11)
_tb_price_type_temp
- _id — int(11) — Primary key — NOT NULL
- price_type_code — varchar(30) — NOT NULL
- product_name — varchar(50) — NOT NULL
- product_code — varchar(30) — NOT NULL
- barcode — varchar(20)
- is_price_type — varchar(1)
- master_price — int(11) — NOT NULL
- master_margin — double — NOT NULL
- master_margin_rate — double — NOT NULL
- master_cost_rate — int(11) — NOT NULL
- price_policy_type1 — int(11) — NOT NULL
- price_margin_rate_type1 — double — NOT NULL
- price_policy_type2 — int(11) — NOT NULL
- price_margin_rate_type2 — double — NOT NULL
- price_policy_type3 — int(11) — NOT NULL
- price_margin_rate_type3 — double — NOT NULL
- price_policy_type4 — int(11) — NOT NULL
- price_margin_rate_type4 — double — NOT NULL
- price_policy_type5 — int(11) — NOT NULL
- price_margin_rate_type5 — double — NOT NULL
- price_policy_type6 — int(11) — NOT NULL
- price_margin_rate_type6 — double — NOT NULL
- price_policy_type7 — int(11) — NOT NULL
- price_margin_rate_type7 — double — NOT NULL
- price_policy_type8 — int(11) — NOT NULL
- price_margin_rate_type8 — double — NOT NULL
- price_policy_type9 — int(11) — NOT NULL
- price_margin_rate_type9 — double — NOT NULL
- price_policy_type10 — int(11) — NOT NULL
- price_margin_rate_type10 — double — NOT NULL
- price_policy_type11 — int(11) — NOT NULL
- price_margin_rate_type11 — double — NOT NULL
- registrant — varchar(50) — NOT NULL
- reg_dt — datetime — NOT NULL
- type_admin — varchar(50)
- type_dt — datetime
- modifier — varchar(50)
- mod_dt — datetime
- price_policy_type12 — int(11)
- price_margin_rate_type12 — double
- price_policy_type13 — int(11)
- price_margin_rate_type13 — double
- price_policy_type14 — int(11)
- price_margin_rate_type14 — double
- price_policy_type15 — int(11)
- price_margin_rate_type15 — double
- price_policy_type16 — int(11)
- price_margin_rate_type16 — double
- price_policy_type17 — int(11)
- price_margin_rate_type17 — double
- price_policy_type18 — int(11)
- price_margin_rate_type18 — double
- price_policy_type19 — int(11)
- price_margin_rate_type19 — double
- price_policy_type20 — int(11)
- price_margin_rate_type20 — double
- price_policy_type21 — int(11)
- price_margin_rate_type21 — double
_tb_product
- barcode — varchar(18)
- product_name — varchar(50)
_tb_purchase_item
- purchase_code — varchar(30) — Primary key — NOT NULL
- product_code — varchar(30) — Primary key — NOT NULL
- _id — int(11) — NOT NULL
- product_name — varchar(30) — NOT NULL
- price — int(11) — NOT NULL
- is_rate — varchar(1)
- rate_company — varchar(11)
- rate_user — varchar(11)
- quantity — int(11) — NOT NULL
- total_price — int(11) — NOT NULL
- refund — varchar(1)
- loss — varchar(1)
- user_rate — double — NOT NULL
- company_rate — double — NOT NULL
- regdate — datetime — NOT NULL
- INDEX — `_id`(`_id`)
_tb_stayminibar_stock_temp
- product_code — varchar(50)
- barcode — varchar(50)
- product_name — varchar(50)
- quantity — int(11)
_tb_stock_temp
- barcode — varchar(50)
- product_name — varchar(50)
- stock_quantity — int(11)
_tmap_phone_rfid
- phone — varchar(50)
- rfid — varchar(128)
file_group
- id — varchar(255) — Primary key — NOT NULL
- name — varchar(255)
- created_at — datetime — NOT NULL
- updated_at — datetime
file_item
- id — varchar(255) — Primary key — NOT NULL
- group_id — varchar(255) — Foreign key → file_group.id — NOT NULL
- filename — varchar(255) — NOT NULL
- path — varchar(500) — NOT NULL
- size — bigint(20) — NOT NULL
- mime_type — varchar(100)
- created_at — datetime — NOT NULL
- INDEX — `fk_file_group`(`group_id`)
flyway_schema_history
- installed_rank — int(11) — Primary key — NOT NULL
- version — varchar(50)
- description — varchar(200) — NOT NULL
- type — varchar(20) — NOT NULL
- script — varchar(1000) — NOT NULL
- checksum — int(11)
- installed_by — varchar(100) — NOT NULL
- installed_on — timestamp — NOT NULL
- execution_time — int(11) — NOT NULL
- success — tinyint(1) — NOT NULL
- INDEX — `flyway_schema_history_s_idx`(`success`)
jv_commit
- commit_pk — bigint(20) — Primary key — NOT NULL
- author — varchar(200)
- commit_date — timestamp(3)
- commit_date_instant — varchar(30)
- commit_id — decimal(22, 2)
- INDEX — `jv_commit_commit_id_idx`(`commit_id`)
jv_commit_property
- property_name — varchar(191) — Primary key — NOT NULL
- commit_fk — bigint(20) — Foreign key → jv_commit.commit_pk — NOT NULL
- property_value — varchar(600)
- INDEX — `jv_commit_property_commit_fk_idx`(`commit_fk`)
- INDEX — `jv_commit_property_property_name_property_value_idx`(`property_name`, `property_value`(191))
jv_global_id
- global_id_pk — bigint(20) — Primary key — NOT NULL
- local_id — varchar(191)
- fragment — varchar(200)
- type_name — varchar(200)
- owner_id_fk — bigint(20) — Foreign key → jv_global_id.global_id_pk
- INDEX — `jv_global_id_local_id_idx`(`local_id`)
- INDEX — `jv_global_id_owner_id_fk_idx`(`owner_id_fk`)
jv_snapshot
- snapshot_pk — bigint(20) — Primary key — NOT NULL
- type — varchar(200)
- version — bigint(20)
- state — text
- changed_properties — text
- managed_type — varchar(200)
- global_id_fk — bigint(20) — Foreign key → jv_global_id.global_id_pk
- commit_fk — bigint(20) — Foreign key → jv_commit.commit_pk
- INDEX — `jv_snapshot_global_id_fk_idx`(`global_id_fk`)
- INDEX — `jv_snapshot_commit_fk_idx`(`commit_fk`)
refresh_token
- id — int(11) — Primary key — NOT NULL
- admin_id — int(11) — NOT NULL
- token — varchar(255) — NOT NULL
- expiry_date — datetime — NOT NULL
- account_code — varchar(100) — NOT NULL
refresh_token_barcode
- id — int(11) — Primary key — NOT NULL
- admin_id — int(11) — Foreign key → tb_admin._id — NOT NULL
- token — varchar(500) — NOT NULL
- expiry_date — datetime — NOT NULL
- INDEX — `FK_refresh_token_barcode_tb_admin`(`admin_id`)
refresh_token_client_admin
- id — int(11) — Primary key — NOT NULL
- client_admin_id — int(11) — NOT NULL
- token — varchar(255) — NOT NULL
- expiry_date — datetime — NOT NULL
tb_ad_content
- id — int(11) — Primary key — NOT NULL
- content_code — varchar(30) — NOT NULL
- content_group_code — varchar(30) — Foreign key → tb_ad_content_group.content_group_code
- content_name — varchar(50) — NOT NULL
- version — int(11) — NOT NULL
- content_type — varchar(20)
- duration_seconds — int(11) — NOT NULL
- download_url — varchar(255) — NOT NULL
- content_hash — varchar(64) — NOT NULL
- file_size — int(11)
- reg_dt — datetime — NOT NULL
- reg_code — varchar(40) — NOT NULL
- edit_dt — datetime
- edit_code — varchar(40)
- INDEX — `tb_ad_content_FK`(`content_group_code`)
tb_ad_content_group
- id — int(11) — Primary key — NOT NULL
- content_group_code — varchar(30) — NOT NULL
- content_group_name — varchar(50) — NOT NULL
- reg_dt — datetime — NOT NULL
- reg_code — varchar(40) — NOT NULL
- edit_dt — datetime
- edit_code — varchar(40)
tb_ad_content_kiosk
- content_code — varchar(30) — Foreign key → tb_ad_content.content_code — NOT NULL
- kiosk_code — varchar(30) — Foreign key — NOT NULL
- play_order — tinyint(4) — NOT NULL
- INDEX — `tb_ad_content_kiosk_FK_1`(`kiosk_code`)
tb_ad_version
- _id — int(11) — Primary key — NOT NULL
- ad_code — varchar(40) — NOT NULL
- ad_name — varchar(40) — NOT NULL
- ad_version — varchar(40)
- ad_link — varchar(1000)
- ad_nickname — varchar(40)
- reg_code — varchar(40) — NOT NULL
- reg_dt — datetime — NOT NULL
- edit_code — varchar(40)
- edit_dt — datetime
tb_admin
- _id — int(11) — Primary key — NOT NULL
- admin_code — varchar(40) — NOT NULL
- user_id — varchar(20) — NOT NULL
- user_pw — varchar(128) — NOT NULL
- name — varchar(20) — NOT NULL
- is_super — varchar(1)
- is_productmaster — varchar(1)
- is_stockmaster — varchar(1)
- is_warehousemaster — varchar(1)
- is_display_manager — varchar(1) — NOT NULL
- pass_try_num — int(11)
- reg_code — varchar(40)
- reg_dt — datetime — NOT NULL
- edit_code — varchar(40)
- edit_dt — datetime
- user_yn — varchar(1) — NOT NULL
- is_client — varchar(1)
- user_code — varchar(40)
tb_admin_token
- _id — int(11) — Primary key — NOT NULL
- admin_code — varchar(40) — NOT NULL
- token — varchar(255) — NOT NULL
- expiry_date — datetime
tb_app_release_info
- id — int(11) — Primary key — NOT NULL
- app_version — varchar(50) — NOT NULL
- download_url — varchar(255) — NOT NULL
- release_dt — datetime — NOT NULL
- created_at — datetime — NOT NULL
- created_by — varchar(30) — NOT NULL
- updated_at — datetime
- updated_by — varchar(30)
tb_app_version
- _id — int(11) — Primary key — NOT NULL
- app_code — varchar(40) — NOT NULL
- app_name — varchar(40) — NOT NULL
- app_version — varchar(40)
- app_link — varchar(150)
- app_group — varchar(40) — NOT NULL
- app_nickname — varchar(40) — NOT NULL
- reg_code — varchar(40) — NOT NULL
- reg_dt — datetime — NOT NULL
- edit_code — varchar(40)
- edit_dt — datetime
tb_banner
- banner_Id — bigint(20) — Primary key — NOT NULL
- display_order — int(11) — NOT NULL
- image_url — varchar(500)
- image_url_mobile — varchar(500)
- link_url — varchar(500)
- start_date — datetime
- end_date — datetime
- is_active — tinyint(1) — NOT NULL
- reg_dt — datetime
- reg_code — varchar(40)
- edit_dt — datetime
- edit_code — varchar(40)
tb_batch_error_log
- _id — int(11) — Primary key — NOT NULL
- curation_code — varchar(30)
- error_message — text
- batch_type — varchar(50) — CURATION_BATCH, ORDER_BATCH, etc
- error_dt — datetime
- resolved — varchar(1) — Y/N - đã xử lý chưa
- resolved_dt — datetime
- resolved_note — text
- INDEX — `idx_curation_code`(`curation_code`)
- INDEX — `idx_error_dt`(`error_dt`)
- INDEX — `idx_resolved`(`resolved`)
tb_billing
- billing_code — varchar(30) — Primary key — NOT NULL — 카드 결제 코드
- _id — int(11) — NOT NULL — 인덱스
- user_code — varchar(30) — NOT NULL — 회원가입 시 부과하는 회원 고유 코드
- billkey — varchar(40) — 카드번호, 가맹번호(mid), 유효일자를 암호화 해서 pg사에서 전달해주는 암호키
- cardno — varchar(16) — 카드 일련 번호
- cardcd — varchar(2) — 카드사 이름에 따른 번호
- cardname — varchar(10) — 카드사 이름
- orderid — varchar(30) — 결제하려는 주문 아이디
- tid — varchar(40) — 승인 후 결과 KEY값
- pgauthdate — varchar(8) — pg사에서 거래를 승인한 날짜
- pgauthtime — varchar(6) — pg사에서 거래를 승인한 시간
- is_main — varchar(1) — 선택된 카드가 메인으로 사용하는 카드인지 여부
- total_amount — decimal(18, 2)
- status — varchar(1) — 0: Pending, 1: Requested, 2: Completed
- reg_dt — datetime
- reg_code — varchar(40)
- edit_dt — datetime
- edit_code — varchar(40)
- INDEX — `_id`(`_id`)
tb_billing_detail
- _id — bigint(20) — Primary key — NOT NULL
- billing_code — varchar(30) — NOT NULL
- order_code — varchar(30) — NOT NULL
- order_amount — decimal(18, 2) — NOT NULL
tb_cart
- _id — int(11) — Primary key — NOT NULL — 인덱스
- cart_code — varchar(30) — NOT NULL
- user_code — varchar(40)
- office_name — varchar(40)
- order_amount — decimal(18, 2) — 발주 금액
- order_yn — varchar(1)
- reg_code — varchar(40)
- reg_dt — datetime
- edit_code — varchar(40)
- edit_dt — datetime — 수정일시
tb_cart_product
- _id — int(11) — Primary key — NOT NULL — 인덱스
- cart_code — varchar(30) — Foreign key → tb_cart.cart_code — NOT NULL
- product_name — varchar(50)
- product_code — varchar(30)
- category1_name — varchar(255)
- category2_name — varchar(255)
- category3_name — varchar(255)
- img_url — varchar(130)
- barcode — varchar(18)
- capacity — varchar(15)
- capacity_type — varchar(10)
- maker — varchar(50)
- vendor_name — varchar(50)
- min_qty — int(11) — 최소 구매 수량
- price — int(11) — 가격
- quantity — int(11) — 발주 수량
- total_price — int(11) — 가격 합계
- reg_code — varchar(50)
- reg_dt — timestamp — 등록일시
- edit_code — varchar(50)
- edit_dt — timestamp — 수정일시
- is_del — varchar(1)
- INDEX — `fk_cart`(`cart_code`)
tb_category
- _id — int(11) — Primary key — NOT NULL
- category_type — varchar(1) — NOT NULL
- category_code — varchar(10) — NOT NULL
- category_name — varchar(20) — NOT NULL
- category_name_eng — varchar(20) — NOT NULL
- reg_dt — datetime — NOT NULL
- reg_code — varchar(40) — NOT NULL
- edit_dt — datetime
- edit_code — varchar(40)
tb_category_1
- _id — int(11) — Primary key — NOT NULL
- category_code_1 — varchar(30) — NOT NULL — 카테고리 코드
- category_name — varchar(30) — 카테고리 이름
- category_name_lang — varchar(30) — 카테고리 이름
- reg_code — varchar(30) — 작성자
- reg_dt — datetime — 작성시간
- edit_code — varchar(30) — 수정자
- edit_dt — datetime — 수정시간
tb_category_2
- _id — int(11) — Primary key — NOT NULL
- category_code_2 — varchar(30) — NOT NULL — 카테고리 코드
- category_code_1 — varchar(30) — Foreign key → tb_category_1.category_code_1 — 카테고리 1차 코드
- category_name — varchar(30) — 카테고리 이름
- category_name_lang — varchar(30)
- reg_code — varchar(30) — 작성자
- reg_dt — datetime — 작성시간
- edit_code — varchar(30) — 수정자
- edit_dt — datetime — 수정시간
- INDEX — `tb_category_2_FK`(`category_code_1`)
tb_category_3
- _id — int(11) — Primary key — NOT NULL
- category_code_3 — varchar(30) — NOT NULL — 카테고리코드
- category_code_2 — varchar(30) — Foreign key → tb_category_2.category_code_2 — 카테고리 2차 코드
- category_code_1 — varchar(30) — Foreign key → tb_category_1.category_code_1 — 카테고리 1차 코드
- category_name — varchar(30) — 카테고리 이름
- category_name_lang — varchar(30)
- reg_code — varchar(30) — 작성자
- reg_dt — datetime — 작성시간
- edit_code — varchar(30) — 수정자
- edit_dt — datetime — 수정시간
- INDEX — `tb_category_3_FK`(`category_code_1`)
- INDEX — `tb_category_3_FK_1`(`category_code_2`)
tb_channel
- _id — int(11) — Primary key — NOT NULL
- channel_code — varchar(30)
- channel_name — varchar(10) — NOT NULL
tb_client
- _id — int(11) — Primary key — NOT NULL
- aggregation_code — varchar(30)
- client_channel — varchar(10) — NOT NULL
- client_channel_code — varchar(30)
- client_name — varchar(30) — NOT NULL
- client_selection_code — varchar(30)
- client_code — varchar(30) — NOT NULL
- group_name — varchar(20)
- group_code — varchar(30)
- manager_name — varchar(20)
- client_contact — varchar(20)
- client_id — varchar(20) — NOT NULL
- owner_name — varchar(20)
- business_number — varchar(20)
- manager_phone — varchar(20)
- business_file_name — varchar(100)
- business_file_link — varchar(200)
- client_address1 — varchar(250)
- client_address2 — varchar(250)
- official_email — varchar(40)
- charger_email — varchar(40)
- contract_term — varchar(10)
- contract_date — varchar(10)
- price_policy_type — varchar(10)
- sales_manager — varchar(10)
- goal_amount — int(11) — NOT NULL
- investment_amount — int(11) — NOT NULL
- note — varchar(256)
- shipping_code — varchar(30)
- reg_code — varchar(40) — NOT NULL
- reg_dt — datetime — NOT NULL
- edit_code — varchar(40)
- edit_dt — datetime
- use_yn — bit(1) — NOT NULL
- preorder_available_yn — bit(1)
- preorder_verification_code — varchar(20)
tb_client_admin
- _id — int(11) — Primary key — NOT NULL
- client_code — varchar(40) — NOT NULL
- user_id — varchar(20) — NOT NULL
- user_pw — varchar(128) — NOT NULL
- session — varchar(128)
- pass_try_num — int(11)
- reg_code — varchar(40)
- reg_dt — datetime — NOT NULL
- edit_code — varchar(40)
- edit_dt — datetime
- enabled — bit(1) — NOT NULL
tb_client_aggregation
- _id — int(11) — Primary key — NOT NULL
- aggregation_code — varchar(30) — NOT NULL
- aggregation_name — varchar(30)
- aggregation_nickname — varchar(30)
tb_client_copy1
- _id — int(11) — Primary key — NOT NULL
- aggregation_code — varchar(30)
- client_channel — varchar(10) — NOT NULL
- client_channel_code — varchar(30)
- client_name — varchar(30) — NOT NULL
- client_selection_code — varchar(30)
- client_code — varchar(30) — NOT NULL
- group_name — varchar(20)
- group_code — varchar(30)
- manager_name — varchar(20)
- client_contact — varchar(20)
- client_id — varchar(20) — NOT NULL
- owner_name — varchar(20)
- business_number — varchar(20)
- manager_phone — varchar(20)
- business_file_name — varchar(100)
- business_file_link — varchar(200)
- client_address1 — varchar(250)
- client_address2 — varchar(250)
- official_email — varchar(40)
- charger_email — varchar(40)
- contract_term — varchar(10)
- contract_date — varchar(10)
- price_policy_type — varchar(10)
- sales_manager — varchar(10)
- goal_amount — int(11) — NOT NULL
- investment_amount — int(11) — NOT NULL
- note — varchar(256)
- shipping_code — varchar(30)
- reg_code — varchar(40) — NOT NULL
- reg_dt — datetime — NOT NULL
- edit_code — varchar(40)
- edit_dt — datetime
- use_yn — varchar(1) — NOT NULL
- preorder_available_yn — varchar(1)
- preorder_verification_code — varchar(20)
tb_client_order
- _id — int(11) — Primary key — NOT NULL
- order_code — varchar(40)
- client_channel — varchar(10)
- client_name — varchar(30)
- client_code — varchar(30)
- minibar_nickname — varchar(30)
- minibar_code — varchar(30)
- request_division — varchar(30)
- request_admin — varchar(40)
- status — varchar(1) — NOT NULL
- reject_yn — varchar(1) — NOT NULL
- reject_reason — varchar(250)
- order_amount — int(11) — NOT NULL
- order_admin — varchar(40)
- order_dt — datetime
- reg_code — varchar(40) — NOT NULL
- reg_dt — datetime — NOT NULL
- edit_code — varchar(40)
- edit_dt — datetime
- picking_admin_code — varchar(50)
- picking_dt — datetime
- use_yn — varchar(1)
- completed_dt — datetime
tb_client_order_product
- _id — int(11) — Primary key — NOT NULL
- order_code — varchar(40) — NOT NULL
- product_name — varchar(50) — NOT NULL
- product_code — varchar(30) — NOT NULL
- category3_code — varchar(30)
- img_url — varchar(130)
- cost — int(11) — NOT NULL
- box — varchar(10)
- capacity_type — varchar(10)
- capacity — varchar(15)
- price_type_code — varchar(30)
- price_type — varchar(2)
- master_price — int(11) — NOT NULL
- price_policy_type — int(11) — NOT NULL
- order_quantity — int(11) — NOT NULL
- total_price — int(11) — NOT NULL
- minibar_location_note — varchar(250)
- use_yn — varchar(1)
- reg_code — varchar(40) — NOT NULL
- reg_dt — datetime — NOT NULL
- edit_code — varchar(40)
- edit_dt — datetime
tb_client_performance
- _id — int(11) — Primary key — NOT NULL
- client_code — varchar(30) — NOT NULL
- client_name — varchar(30)
- client_performance_code — varchar(30)
- file_name — varchar(100)
- file_link — varchar(200)
- reg_code — varchar(40)
- date — varchar(30)
- reg_dt — datetime — NOT NULL
tb_client_preference
- _id — int(11) — Primary key — NOT NULL
- aggregation_code — varchar(100)
- client_preference_code — varchar(30) — NOT NULL
- client_code — varchar(30)
- minibar_code — varchar(30)
- main_category — varchar(50)
- sub_category — varchar(50)
- payment — varchar(20)
- is_return — varchar(1)
- return_per — varchar(10)
- is_rental — varchar(1)
- rental_month_price — varchar(30)
- is_operation_type — varchar(1)
- operation_type — varchar(30)
- is_number_of_employee — varchar(1)
- number_of_employee — varchar(1)
- is_number_of_display — varchar(1)
- number_of_display — varchar(30)
- is_lc_fee — varchar(1)
- lc_fee — varchar(30)
- is_external_fee — varchar(1)
- external_fee — varchar(30)
- deadline_date — date
- deposit_date — date
- is_router_fee — varchar(1)
- router_fee — varchar(30)
- revenue_check — varchar(100)
- note — varchar(100)
tb_client_recontract
- _id — int(11) — Primary key — NOT NULL
- client_code — varchar(30) — NOT NULL
- recontract_period — varchar(20)
- recontract_date — datetime
- reg_code — varchar(40) — NOT NULL
- reg_dt — datetime — NOT NULL
tb_code
- _id — int(11) — Primary key — NOT NULL
- phone — varchar(150) — NOT NULL
- code — varchar(4) — NOT NULL
- reg_dt — datetime — NOT NULL