License
Tables (15)
APP_INFOS
- APP_INFO_ID — BIGINT — Primary key — NOT NULL
- ANDROID_DISPLAY
- ANDROID_PACKAGE_NAME — NOT NULL
- IOS_DISPLAY — NOT NULL
- IOS_PACKAGE_NAME — NOT NULL
- SERVER_DISPLAY — NOT NULL
- SERVER_PACKAGE_NAME — NOT NULL
CLIENT_INFOS
- CLIENT_INFO_ID — BIGINT — Primary key — NOT NULL
- NAME
- MANAGER_NAME — NOT NULL
- MANAGER_EMAIL — NOT NULL
- MANAGER_TEL — NOT NULL
GENERATORS
- GENERATORS_ID — BIGINT — Primary key — NOT NULL
- USER_ID — Foreign key → USERS.USER_ID — NOT NULL
- LICENSE_VERSION_ID — Foreign key → LICENSE_VERSION.LICENSE_VERSION_ID — NOT NULL
- CHANGES — LONGBLOB
- COMPATIBILITY — LONGBLOB
- NOTE — LONGBLOB — NOT NULL
- CREATED_DATE — TIMESTAMP
- RELEASE_DATE — TIMESTAMP
- UPDATED_DATE — TIMESTAMP
LICENSE
- LICENSE_ID — BIGINT — Primary key — NOT NULL
- CLIENT_INFO_ID — Foreign key → CLIENT_INFOS.CLIENT_INFO_ID — NOT NULL
- USER_ID — Foreign key → USERS.USER_ID — NOT NULL
- LICENSE_FILES_ID — Foreign key → LICENSE_FILES.LICENSE_FILES_ID — NOT NULL
- PROJECT_ID — Foreign key → Project.PROJECT_ID — NOT NULL
- SOLUTION_DELIVERIES_ID — Foreign key → SOLUTION_DELIVERIES.SOLUTION_DELIVERIES_ID — NOT NULL
- TEMPLATES_ID — Foreign key → TEMPLATES.TEMPLATES_ID — NOT NULL
- APP_INFO_ID — BIGINT — Foreign key → APP_INFOS.APP_INFO_ID — NOT NULL
- PROJECTS_STATE_ID — BIGINT — Foreign key → PROJECTS_STATE.PROJECTS_STATE_ID — NOT NULL
- SALES_PERSON_ID — BIGINT — Foreign key → SALES_PERSON.SALES_PERSON_ID — NOT NULL
- SALES_STATE_ID — BIGINT — Foreign key → SALES_STATE.SALES_STATE_ID — NOT NULL
- SOLUTION_ID — BIGINT — Foreign key → SOLUTION.SOLUTION_ID — NOT NULL
- CREATE_DATE — TIMESTAMP
- MODE
- LICENSE_TYPE
- HOST_ID — NOT NULL
- IP_ADDRESS — NOT NULL
- LICENSE_FROM — TIMESTAMP
- LICENSE_TO — TIMESTAMP
- FILENAME
- NOTE_NAME — NOT NULL
- NOTE_VALUE — NOT NULL
- PACKAGE_NAME — NOT NULL
- UPDATED_DATE — TIMESTAMP
- ACTIVE
LICENSE_FILES
- LICENSE_FILES_ID — BIGINT — Primary key — NOT NULL
- MODE
- UUID
- FILENAME
- PATH
- DISABLED — NOT NULL
LICENSE_VERSION
- LICENSE_VERSION_ID — BIGINT — Primary key — NOT NULL
- VERSION
POLICIES
- POLICIES_ID — BIGINT — Primary key — NOT NULL
- USER_ID — Foreign key → USERS.USER_ID — NOT NULL
- SOLUTION_ID — Foreign key → SOLUTION.SOLUTION_ID — NOT NULL
- TITLE
- CONTENT — LONGBLOB — NOT NULL
- CREATE_DATE — TIMESTAMP
- ISENABLE
- UPDATED_DATE — TIMESTAMP
PROJECTS_STATE
- PROJECTS_STATE_ID — BIGINT — Primary key — NOT NULL
- STATE
- ACTIVE — NOT NULL
Project (PROJECT)
- PROJECT_ID — BIGINT — Primary key — NOT NULL
- APP_INFO_ID — Foreign key → APP_INFOS.APP_INFO_ID — NOT NULL
- CLIENT_INFO_ID — Foreign key → CLIENT_INFOS.CLIENT_INFO_ID — NOT NULL
- LICENSE_FILES_ID — Foreign key → LICENSE_FILES.LICENSE_FILES_ID — NOT NULL
- PROJECTS_STATE_ID — Foreign key → PROJECTS_STATE.PROJECTS_STATE_ID — NOT NULL
- SALES_PERSON_ID — Foreign key → SALES_PERSON.SALES_PERSON_ID — NOT NULL
- SALES_STATE_ID — Foreign key → SALES_STATE.SALES_STATE_ID — NOT NULL
- SOLUTION_DELIVERIES_ID — Foreign key → SOLUTION_DELIVERIES.SOLUTION_DELIVERIES_ID — NOT NULL
- CREATED_DATE — TIMESTAMP
- JIRA_LINK
- LICENSE_FROM — TIMESTAMP
- LICENSE_TO — TIMESTAMP
- NAME
- NOTE — LONGBLOB — NOT NULL
- PRACTITIONER
- TECH_NOTE — LONGBLOB — NOT NULL
- UPDATED_DATE — TIMESTAMP
SALES_PERSON
- SALES_PERSON_ID — BIGINT — Primary key — NOT NULL
- NAME
- ACTIVE — NOT NULL
SALES_STATE
- SALES_STATE_ID — BIGINT — Primary key — NOT NULL
- STATE
- ACTIVE — NOT NULL
SOLUTION
- SOLUTION_ID — BIGINT — Primary key — NOT NULL
- NAME
- ACTIVE — NOT NULL
SOLUTION_DELIVERIES
- SOLUTION_DELIVERIES_ID — BIGINT — Primary key — NOT NULL
- SERVICE_NAME
- TYPE
TEMPLATES
- TEMPLATES_ID — BIGINT — Primary key — NOT NULL
- USER_ID — Foreign key → USERS.USER_ID — NOT NULL
- SOLUTION_ID — Foreign key → SOLUTION.SOLUTION_ID — NOT NULL
- ACTIVE
- CREATE_DATE — TIMESTAMP
- MODE
- LICENSE_TYPE — NOT NULL
- HOST_ID — NOT NULL
- IP_ADDRESS — NOT NULL
- LICENSE_FROM — TIMESTAMP — NOT NULL
- LICENSE_TO — TIMESTAMP — NOT NULL
- NAME
- NOTE_NAME
- NOTE_VALUE
- UPDATED_DATE — TIMESTAMP
USERS
- USER_ID — BIGINT — Primary key — NOT NULL
- AUTHORITIES — NOT NULL
- NAME
- PASSWORD
- SECRETKEY
- DEPARTMENT
- CREATE_DATE — TIMESTAMP
- UPDATED_DATE — TIMESTAMP
- ACTIVE — NOT NULL