Lashic Link

Tables (5)

Lashic_Link_company (Null)

  • int (id) — No — Primary key — NOT NULL
  • int (login_user_id) — No — Primary key — NOT NULL
  • int\ (connect_kakugen_group_id) — No — Primary key — NOT NULL
  • varcher (menu_nm) — ok
  • int (branch)
  • int (status)
  • intk (kengen)
  • date (start_date)
  • date (end_date)
  • int (offcial)
  • varchar (line_bot_api)
  • varchar (handler)
  • text (kanri_userids)
  • int (max_group_number)
  • int (service_category)
  • int (template_type)

Lashic_connect_group_line (?)

  • int (id) — pk — Primary key — NOT NULL
  • int (company_id) — fk — Primary key — NOT NULL
  • int (connect_company_id) — fk — Primary key — NOT NULL
  • int (no)
  • varcher (group_id)
  • varchar (name)
  • int (people)
  • varcharp (pictureurl)
  • int (status)
  • int (anpi_check)
  • int (kakugen)

Lashic_link_group_anpui_setting (Untitled3)

  • int (id) — PK — Primary key — NOT NULL
  • int (company_id) — FK — Primary key — NOT NULL
  • int (connect_company_id) — string — Primary key — NOT NULL
  • int (connect_group_line_id) — string — Primary key — NOT NULL
  • date (start_date)
  • ints (send_day)
  • int (send_hour)
  • int (send_wday)
  • int (stop_flg)

lashic_connect_group_anpi (Untitled2)

  • int (id) — PK — Primary key — NOT NULL
  • int (company_id) — FK — Primary key — NOT NULL
  • int (connect_company_id) — FK — Primary key — NOT NULL
  • int (connect_group_line_id) — FK — Primary key — NOT NULL
  • varchar (user_id)
  • int (retry)
  • datetime (time_send)
  • datetimet (ime_reply)

lashic_link_line_member (Untitled)

  • int (id) — PK — Primary key — NOT NULL
  • int (company_id) — FK — Primary key — NOT NULL
  • int (connect_group_line_id) — FK — Primary key — NOT NULL
  • varchar (userid)
  • date (expire)
  • int (kanri_flg)