account

Tables (5)

account list (NMAccountBook)

  • unique oid (OID) — text — Primary key — NOT NULL
  • user oid (USER_OID) — text — Foreign key → user.unique id — NOT NULL
  • created date (CREATED_DATE) — timestamp
  • modified date (MODIFIED_DATE) — timestamp
  • account description (DESCRIPTION) — varchar(1000)
  • income (INCOME) — numeric(15, 3)
  • outcome (OUTCOME) — numberic(15, 3)
  • delete or not (IS_DELETE) — boolean

config option (NMConfig)

  • unique id (OID) — text — Primary key — NOT NULL
  • config name (NAME) — varchar(32) — NOT NULL
  • config value (VALUE) — varchar(1024)
  • config descropttion (DESCRIPTION) — text
  • create date (CREATED_DATE) — timestamp — NOT NULL
  • modiffied date (MODIFIED_DATE) — timestamp
  • config enable (IS_ENABLE) — boolean
  • delete or not (IS_DELETE) — boolean

history (NMLog)

  • unique id (OID) — text — Primary key — NOT NULL
  • user oid (USER_OID) — text — Foreign key → user.unique id — NOT NULL
  • crud type (CRUD_TYPE) — char(1) — NOT NULL
  • action type (ACTION_TYPE) — varchar(4) — NOT NULL
  • target oid (TARGET_OID) — text — NOT NULL
  • delete or not (IS_DELETE) — boolean — NOT NULL

tag (NMTag)

  • unique id (OID) — text — Primary key — NOT NULL
  • tag name (NAME) — varchar(32)
  • created date (CREATED_DATE) — timestamp
  • modified date (MODIFIED_DATE) — timestamp
  • target type (TARGET_TYPE) — varchar(4)
  • target oid (TARGET_OID) — text

user (NMUser)

  • unique id (OID) — text — Primary key — NOT NULL
  • user account (ACCOUNT) — varchar(32)
  • join date (JOIN_DATE) — timestamp — NOT NULL
  • last login date (LAST_LOGIN_DATE) — timestamp
  • nickname (NICKNAME) — varchar(16) — NOT NULL
  • account password (PWD) — text — NOT NULL
  • delete or not (IS_DELETE) — boolean — NOT NULL