Планфикс. Подключение коннектора
Дата:
Описание таблиц в базе данных
Каждый источник данных создает набор таблиц в вашей базе данных
Во вкладках ниже вы сможете найти шаблон имени таблицы и описание создаваемых колонок в таблице
Название таблицы:
planfix_{}_projects
| Название колонки | Описание |
|---|---|
project_id |
Project ID |
title |
Project name |
description |
Description |
status |
Status |
hidden |
Hidden |
hasEndDate |
Has an end date |
taskCount |
Number of tasks |
isOverdued |
Overdue |
isCloseToDeadline |
25% of the time left before completion or 75% of the allotted time has passed |
beginDate |
Date created |
owner_id |
Owner ID |
owner_name |
Owner name |
client_id |
Client ID |
client_name |
Client name |
template_id |
Template ID |
group_id |
Group ID |
group_name |
Group name |
parent_id |
Parent ID |
customData_customValue |
User data (JSON) |
customData |
User data |
Название таблицы:
planfix_{}_tasks
| Название колонки | Описание |
|---|---|
task_id |
Task ID |
date |
Date the task was created |
title |
Title |
description |
Description |
importance |
Importance |
status |
Status |
statusSet |
Task process ID |
checkResult |
With result check |
beginDateTime |
Task creation date |
startTime |
Start date |
endTime |
End date |
general |
Cross reference number |
isOverdued |
Overdue |
isCloseToDeadline |
Close to deadline |
isNotAcceptedInTime |
Not accepted on time |
starred |
Starred |
owner_id |
Owner ID |
owner_name |
Owner name |
parent_id |
Parent ID |
template_id |
Template ID |
project_id |
Project ID |
project_title |
Project title |
client_id |
Client ID |
client_name |
Client name |
duration |
Duration |
durationUnit |
0 - minutes, 1 - hours, 2 - days |
workers_users_user_id |
Assignees ID |
workers_users_user_name |
Assignees names |
workers_groups_group_id |
Assignees group ID |
workers_groups_group_name |
Assignees group name |
workers |
Assignees |
Название таблицы:
planfix_{}_users
| Название колонки | Описание |
|---|---|
user_id |
User ID |
name |
User name |
lastName |
Last name |
login |
Login |
email |
|
role |
Role |
status |
Status |
isActivated |
Active |
birthdate |
Birthdate |
sex |
Gender |
timezone |
Timezone |
isInvisibleOutOfGroup |
Sees only members of their groups |
isBlindOutOfGroup |
Only members of his groups see them |
userPic |
Full URL to the picture |
isOnline |
Online |
post_id |
Position ID |
post_name |
Position name |
userGroups_userGroup_id |
Group ID |
userGroups_userGroup_name |
Group name |
phones_phone_number |
Phone |
phones_phone_typeId |
Phone type ID |
phones_phone_typeName |
Phone type name |
phones |
Phones |
userGroups_userGroup |
Usergroups Usergroup |
Название таблицы:
planfix_{}_actions
| Название колонки | Описание |
|---|---|
action_id |
Action ID |
description |
Description |
type |
Type |
date |
Date created |
oldStatus |
Old status |
newStatus |
New status |
task_id |
Task ID |
task_title |
Task title |
project_id |
Project ID |
project_title |
Project name |
owner_id |
Owner ID |
owner_name |
Owner name |
analitic |
List of attached analytics |
Название таблицы:
planfix_{}_analitics
| Название колонки | Описание |
|---|---|
date |
Date and time of creation |
name |
Field name |
value |
Value |
value_id |
Value ID |
analitic_key |
Analytics Key |
action_id |
Action ID |
task_id |
Task ID |
Название таблицы:
planfix_{}_task_status_sets
| Название колонки | Описание |
|---|---|
status_set_id |
Process ID |
name |
Process name |
Название таблицы:
planfix_{}_task_statuses
| Название колонки | Описание |
|---|---|
status_id |
Task status ID |
status_set_id |
Process ID |
name |
Task status name |
isActive |
Status active or inactive |
hasDeadline |
Whether deadlines of tasks in this status tracked or not. If deadlines in this status are tracked and the task is in this status after the planned completion date, it becomes overdue |
color |
Colour |
Название таблицы:
planfix_{}_contacts
| Название колонки | Описание |
|---|---|
contact_id |
Contact ID |
userid |
Contact ID for cases when it is used in the system on a par with employees (task executor, etc., as well as a user field of the contact type) |
general |
Contact number |
customData |
Values of custom task fields |
name |
Name |
midName |
Middle name |
lastName |
Last name |
isCompany |
is company |
post |
Position |
email |
|
site |
Site |
phones |
Phones |
address |
Address |
description |
Additional information |
sex |
Gender |
skype |
Skype |
icq |
ICQ |
canBeWorker |
Displayed in the list of task participants |
canBeClient |
Displayed in the list of task clients |
contractors |
List of clients to which contact relates |
userPic |
Picture link |
birthdate |
Birthdate |
havePlanfixAccess |
Does the contact have access to Planfix |
template_id |
Template ID |
group_id |
Contacts group ID |
group_name |
Group name |
mobilePhone |
Phone number |
phones_phone_number |
Phone number |
phones_phone_typeId |
Phone type ID |
phones_phone_typeName |
Phone type name |
contractors_client_id |
Company ID |
contractors_client_name |
Company name |
workPhone |
Work phone number |
phones_phone |
Phone number |
homePhone |
Home phone number |