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