URL: GET kb.sportcrm.club/assets/id/setup/club_setup.php?key=4e3e50fb-fec4-4fa6-8e68-7bcf8fd36359&mode=db,res
[
    {
        "id_changes": {
            "id": null,
            "sportsmen": null,
            "chfield": null,
            "chid": null,
            "trainer": null,
            "newvalue": null,
            "oldvalue": null,
            "info": null,
            "created": null,
            "author": null
        },
        "id_city": {
            "id": null,
            "name": null,
            "extended": null,
            "alias": null,
            "fullname": null,
            "address": null,
            "chief": null,
            "inn": null,
            "ogrn": null,
            "kpp": null,
            "tel": null,
            "email": null,
            "bankname": null,
            "bankbik": null,
            "bankks": null,
            "bankrs": null,
            "timezone": null,
            "menuindex": null,
            "published": null
        },
        "id_club": {
            "id": null,
            "name": null,
            "city": null,
            "address": null,
            "content": null,
            "published": null
        },
        "id_config": {
            "id": null,
            "name": null,
            "val": null,
            "edited": null,
            "editedby": null
        },
        "id_contact": {
            "id": null,
            "parent": null,
            "sportsmen": null,
            "ctype": null,
            "ismain": null,
            "val": null,
            "info": null,
            "folder": null,
            "created": null,
            "author": null
        },
        "id_event": {
            "id": null,
            "status": null,
            "name": null,
            "datestart": null,
            "dateend": null,
            "location": null,
            "info": null,
            "published": null,
            "uniqreg": null,
            "author": null,
            "created": null
        },
        "id_eventcategory": {
            "id": null,
            "name": null,
            "idevent": null,
            "alias": null,
            "menuindex": null,
            "published": null,
            "canreg": null,
            "limits": null,
            "typeinvoice": null
        },
        "id_eventmember": {
            "id": null,
            "sportsmen": null,
            "idevent": null,
            "ideventcategory": null,
            "place": null,
            "result": null,
            "team": null,
            "created": null,
            "author": null,
            "edited": null,
            "editedby": null,
            "idinvoice": null
        },
        "id_expense": {
            "id": null,
            "dateexpense": null,
            "sum": null,
            "typeexpense": null,
            "city": null,
            "info": null,
            "plan": null,
            "created": null,
            "author": null,
            "edited": null,
            "editedby": null
        },
        "id_extid": {
            "id": null,
            "parent": null,
            "extype": null,
            "extid": null,
            "extoken": null,
            "created": null,
            "duedate": null,
            "extended": null
        },
        "id_files": {
            "id": null,
            "key": null,
            "uid": null,
            "name": null,
            "filetype": null,
            "fileext": null,
            "filesize": null,
            "author": null,
            "created": null,
            "incloud": null,
            "hasmime": null
        },
        "id_invoice": {
            "id": null,
            "sportsmen": null,
            "typeinvoice": null,
            "dateinvoice": null,
            "duedate": null,
            "sum": null,
            "oldsum": null,
            "status": null,
            "isauto": null,
            "lesson_amount": null,
            "info": null,
            "created": null,
            "author": null,
            "edited": null,
            "editedby": null
        },
        "id_invoicepay": {
            "created": null,
            "idinvoice": null,
            "idpay": null,
            "sum": null
        },
        "id_invoicetype": {
            "id": null,
            "name": null,
            "amount": null,
            "priceamount": null,
            "price": null,
            "period": null,
            "city": null,
            "menuindex": null,
            "published": null,
            "auto": null
        },
        "id_lead": {
            "id": null,
            "gender": null,
            "status": null,
            "name": null,
            "birth": null,
            "contact": null,
            "tel": null,
            "email": null,
            "trainer": null,
            "sport": null,
            "club": null,
            "squad": null,
            "datestart": null,
            "source": null,
            "info": null,
            "key": null,
            "sportsmen": null,
            "idcontact": null,
            "taskdate": null,
            "author": null,
            "created": null,
            "edited": null,
            "editedby": null,
            "extid": null
        },
        "id_lesson": {
            "id": null,
            "status": null,
            "mark": null,
            "schedule": null,
            "sportsmen": null,
            "created": null,
            "edited": null,
            "author": null,
            "editedby": null,
            "info": null,
            "idinvoice": null
        },
        "id_levels": {
            "id": null,
            "name": null
        },
        "id_msg": {
            "id": null,
            "type": null,
            "msg_to": null,
            "msg_subj": null,
            "info": null,
            "ready": null,
            "attempt": null,
            "datestart": null,
            "created": null,
            "author": null,
            "extended": null,
            "provider": null,
            "datesend": null,
            "datedelivery": null,
            "dateread": null,
            "extid": null,
            "checksum": null
        },
        "id_orderitems": {
            "id": null,
            "status": null,
            "shopitem": null,
            "price": null,
            "amount": null,
            "total": null,
            "opts": null,
            "created": null,
            "author": null,
            "edited": null,
            "editedby": null,
            "info": null,
            "extended": null,
            "orderpack": null
        },
        "id_orderpack": {
            "id": null,
            "name": null,
            "tel": null,
            "datepay": null,
            "receipt": null,
            "sportsmen": null,
            "city": null,
            "club": null,
            "address": null,
            "info": null,
            "extended": null,
            "created": null,
            "author": null,
            "edited": null,
            "editedby": null
        },
        "id_pay": {
            "id": null,
            "sportsmen": null,
            "datepay": null,
            "sum": null,
            "numpay": null,
            "sumbank": null,
            "idinvoice": null,
            "receipt": null,
            "extid": null,
            "code1c": null,
            "info": null,
            "ptype": null,
            "created": null,
            "author": null,
            "edited": null,
            "editedby": null
        },
        "id_remain": {
            "parent": null,
            "rtype": null,
            "sportsmen": null,
            "val": null,
            "sum": null
        },
        "id_schedule": {
            "id": null,
            "stype": null,
            "status": null,
            "planfact": null,
            "repeat": null,
            "parent": null,
            "datestart": null,
            "dateend": null,
            "duration": null,
            "duedate": null,
            "trainer": null,
            "trainer2": null,
            "squad": null,
            "club": null,
            "sport": null,
            "location": null,
            "link": null,
            "idevent": null,
            "info": null,
            "created": null,
            "author": null
        },
        "id_shopitem": {
            "id": null,
            "name": null,
            "price": null,
            "info": null,
            "opts": null,
            "menuindex": null,
            "published": null,
            "status": null
        },
        "id_sinvtype": {
            "id": null,
            "stype": null,
            "typeinvoice": null
        },
        "id_sports": {
            "id": null,
            "name": null,
            "shortname": null,
            "color": null,
            "content": null,
            "menuindex": null,
            "published": null
        },
        "id_sportsmen": {
            "id": null,
            "key": null,
            "gender": null,
            "status": null,
            "name": null,
            "birth": null,
            "doc": null,
            "contract": null,
            "contractdate": null,
            "saldo": null,
            "contact": null,
            "tel": null,
            "email": null,
            "idcontact": null,
            "height": null,
            "weight": null,
            "pasp": null,
            "insdate": null,
            "meddate": null,
            "discount": null,
            "razr": null,
            "city": null,
            "squad": null,
            "trainer": null,
            "taskdate": null,
            "iduser": null,
            "info": null,
            "created": null,
            "author": null,
            "code1c": null
        },
        "id_sportsmendate": {
            "id": null,
            "sportsmen": null,
            "datestart": null,
            "duedate": null,
            "dtype": null,
            "val": null,
            "info": null,
            "created": null,
            "author": null
        },
        "id_sportsmeninvtype": {
            "id": null,
            "sportsmen": null,
            "stype": null,
            "typeinvoice": null,
            "price": null,
            "linked": null,
            "created": null,
            "author": null
        },
        "id_sportsmensquad": {
            "id": null,
            "published": null,
            "sportsmen": null,
            "squad": null,
            "created": null,
            "author": null,
            "dateend": null,
            "editedby": null
        },
        "id_squad": {
            "id": null,
            "name": null,
            "sport": null,
            "lvl": null,
            "trainer": null,
            "club": null,
            "limits": null,
            "published": null,
            "lead": null
        },
        "id_status": {
            "id": null,
            "name": null,
            "tbl": null,
            "alias": null,
            "cls": null,
            "ico": null,
            "menuindex": null,
            "published": null,
            "info": null,
            "extended": null,
            "club_id": null,
            "edited": null,
            "editedby": null
        },
        "id_talk": {
            "id": null,
            "ctype": null,
            "status": null,
            "localcontact": null,
            "foreigncontact": null,
            "created": null,
            "duration": null,
            "recording": null,
            "info": null,
            "iduser": null,
            "extid": null,
            "extended": null
        },
        "id_tascom": {
            "id": null,
            "uid": null,
            "action": null,
            "name": null,
            "info": null,
            "extid": null,
            "author": null,
            "created": null,
            "extended": null
        },
        "id_task": {
            "id": null,
            "ttype": null,
            "parent": null,
            "tbl": null,
            "duedate": null,
            "oldduedate": null,
            "notifydate": null,
            "dateend": null,
            "oncontrol": null,
            "info": null,
            "result": null,
            "prev": null,
            "assignedto": null,
            "author": null,
            "created": null,
            "editedby": null,
            "edited": null,
            "controlled": null,
            "controlledby": null
        },
        "id_trainer": {
            "id": null,
            "name": null,
            "gender": null,
            "birth": null,
            "uid": null,
            "city": null,
            "begindate": null,
            "meddate": null,
            "tel": null,
            "email": null,
            "sport": null,
            "categ": null,
            "referee": null,
            "content": null,
            "iduser": null,
            "published": null
        }
    },
    {
        "error": [],
        "ok": [],
        "vers": 1247,
        "key": "4e3e50fb-fec4-4fa6-8e68-7bcf8fd36359",
        "mode": [
            "db",
            "res"
        ],
        "enumField": [
            [
                "status",
                {
                    "TABLE_NAME": "id_sportsmen",
                    "COLUMN_NAME": "status",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "Действует"
                },
                {
                    "dbtype": "enum",
                    "precision": "'Действует','Архив'",
                    "phptype": "string",
                    "null": false,
                    "default": "Действует",
                    "enumTbl": "idSportsmen",
                    "enumAlias": "name",
                    "index": "index",
                    "club_log": "1",
                    "_join": "true"
                }
            ],
            [
                "discount",
                {
                    "TABLE_NAME": "id_sportsmen",
                    "COLUMN_NAME": "discount",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "-"
                },
                {
                    "dbtype": "enum",
                    "precision": "'10%','20%','100%','-'",
                    "default": "-",
                    "phptype": "string",
                    "null": false,
                    "enumTbl": "Discount",
                    "enumAlias": "name",
                    "club_log": "1"
                }
            ],
            [
                "razr",
                {
                    "TABLE_NAME": "id_sportsmen",
                    "COLUMN_NAME": "razr",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "-"
                },
                {
                    "dbtype": "enum",
                    "precision": "'I','II','III','-'",
                    "default": "-",
                    "phptype": "string",
                    "null": false,
                    "enumTbl": "idSportsmenGrade",
                    "enumAlias": "name",
                    "club_log": "1"
                }
            ],
            [
                "ctype",
                {
                    "TABLE_NAME": "id_contact",
                    "COLUMN_NAME": "ctype",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "-"
                },
                {
                    "dbtype": "enum",
                    "precision": "'tel','email','bank','text','telegram','telegroup','whatsgroup','viber','max','vk','instagram'",
                    "phptype": "string",
                    "null": false,
                    "default": "tel",
                    "enumTbl": "idContactType"
                }
            ],
            [
                "ptype",
                {
                    "TABLE_NAME": "id_pay",
                    "COLUMN_NAME": "ptype",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "cash"
                },
                {
                    "dbtype": "enum",
                    "precision": "'cash', 'bank', 'acq', 'c1'",
                    "phptype": "string",
                    "null": false,
                    "default": "cash",
                    "enumTbl": "idPayType",
                    "_join": "true"
                }
            ],
            [
                "stype",
                {
                    "TABLE_NAME": "id_sinvtype",
                    "COLUMN_NAME": "stype",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "a"
                },
                {
                    "dbtype": "enum",
                    "precision": "'a','i','o'",
                    "default": "a",
                    "enumTbl": "idSchedule",
                    "phptype": "string",
                    "null": false,
                    "index": "index"
                }
            ],
            [
                "stype",
                {
                    "TABLE_NAME": "id_sportsmeninvtype",
                    "COLUMN_NAME": "stype",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "a"
                },
                {
                    "dbtype": "enum",
                    "precision": "'a','i','o'",
                    "default": "a",
                    "enumTbl": "idSchedule",
                    "phptype": "string",
                    "null": false,
                    "index": "index"
                }
            ],
            [
                "dtype",
                {
                    "TABLE_NAME": "id_sportsmendate",
                    "COLUMN_NAME": "dtype",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "-"
                },
                {
                    "dbtype": "enum",
                    "precision": "'meddate','insdate','razrdate'",
                    "default": "meddate",
                    "enumTbl": "idSportsmenDate",
                    "phptype": "string",
                    "null": false
                }
            ],
            [
                "referee",
                {
                    "TABLE_NAME": "id_trainer",
                    "COLUMN_NAME": "referee",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "-"
                },
                {
                    "dbtype": "enum",
                    "precision": "'3 категория','2 категория','1 категория','Всероссийская','Международная','-'",
                    "default": "-",
                    "phptype": "string",
                    "null": false,
                    "enumTbl": "TrainerRank",
                    "enumAlias": "name"
                }
            ],
            [
                "stype",
                {
                    "TABLE_NAME": "id_schedule",
                    "COLUMN_NAME": "stype",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "a"
                },
                {
                    "dbtype": "enum",
                    "precision": "'a','i','o'",
                    "default": "a",
                    "enumTbl": "idSchedule",
                    "phptype": "string",
                    "null": false,
                    "index": "index",
                    "_join": "true"
                }
            ],
            [
                "status",
                {
                    "TABLE_NAME": "id_lesson",
                    "COLUMN_NAME": "status",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "n"
                },
                {
                    "dbtype": "enum",
                    "precision": "'y','n','t'",
                    "phptype": "string",
                    "null": false,
                    "default": "n",
                    "enumTbl": "idLesson",
                    "index": "index"
                }
            ],
            [
                "status",
                {
                    "TABLE_NAME": "id_shopitem",
                    "COLUMN_NAME": "status",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "c"
                },
                {
                    "dbtype": "enum",
                    "precision": "'c','d'",
                    "default": "c",
                    "phptype": "string",
                    "null": false,
                    "enumTbl": "idShopItem",
                    "index": "index"
                }
            ],
            [
                "status",
                {
                    "TABLE_NAME": "id_orderitems",
                    "COLUMN_NAME": "status",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "cart"
                },
                {
                    "dbtype": "enum",
                    "precision": "'cart','process','payd','work','transport','wait','done','cancel','empty'",
                    "default": "cart",
                    "enumTbl": "idOrderItems",
                    "phptype": "string",
                    "null": false,
                    "index": "index"
                }
            ],
            [
                "status",
                {
                    "TABLE_NAME": "id_event",
                    "COLUMN_NAME": "status",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "Соревнования"
                },
                {
                    "dbtype": "enum",
                    "precision": "'Соревнования','Сборы','Нормативы'",
                    "default": "Соревнования",
                    "phptype": "string",
                    "null": false,
                    "enumTbl": "idEvent",
                    "enumAlias": "name",
                    "_join": "true"
                }
            ],
            [
                "status",
                {
                    "TABLE_NAME": "id_lead",
                    "COLUMN_NAME": "status",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "c"
                },
                {
                    "dbtype": "enum",
                    "precision": "'c','i','d','a','r','z','x'",
                    "default": "c",
                    "phptype": "string",
                    "null": false,
                    "enumTbl": "idLead",
                    "index": "index"
                }
            ],
            [
                "ttype",
                {
                    "TABLE_NAME": "id_task",
                    "COLUMN_NAME": "ttype",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "remind"
                },
                {
                    "dbtype": "enum",
                    "precision": "'remind','specify','contact','todo'",
                    "default": "remind",
                    "phptype": "string",
                    "enumTbl": "idTask",
                    "null": false
                }
            ],
            [
                "tbl",
                {
                    "TABLE_NAME": "id_status",
                    "COLUMN_NAME": "tbl",
                    "DATA_TYPE": "enum",
                    "IS_NULLABLE": "NO",
                    "COLUMN_DEFAULT": "-"
                },
                {
                    "dbtype": "enum",
                    "precision": "'idStatus','i18n','lang','l10n','kb','Gender','idSportsmen','idSportsmenDate','idSportsmenGrade','Discount','ecard','eCardFields','eform','idConfig','idContactType','idEvent','idExpense','idExtid','idFileType','idHelp','idHTML','idLead','idLesson','idModule','idMsgProvider','idOrderItems','idPay','idPayMethod','idPayType','idPermission','idReport','idSchedule','idShopItem','idSource','idTalk','idTalkType','idTask','idTmpl','Interface','TrainerCategory','TrainerRank','SetupScript','-'",
                    "default": "-",
                    "phptype": "string",
                    "null": false,
                    "enumTbl": "idStatus",
                    "index": "index"
                }
            ]
        ]
    }
]