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