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)