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
  • EMAIL
  • PASSWORD
  • SECRETKEY
  • DEPARTMENT
  • CREATE_DATE — TIMESTAMP
  • UPDATED_DATE — TIMESTAMP
  • ACTIVE — NOT NULL