RAS_ERD
Tables (10)
assets
- code — VARCHAR — Primary key — NOT NULL
- description — VARCHAR
- token_address — VARCHAR — Foreign key → security_token.address
- start_date — TIMESTAMP
- end_date — TIMESTAMP
- registered_date — TIMESTAMP
- image — VARCHAR
- name — VARCHAR
- issuer_id — VARCHAR — Foreign key → portal_user.id — NOT NULL
- summary — VARCHAR
- max_supply — INTEGER
- max_inv — INTEGER
- min_inv — INTEGER
- min_supply — INTEGER
- issuer_amount — INTEGER
- status — INTEGER
- number_of_public_offering — INTEGER
contract
- name — VARCHAR — Primary key — NOT NULL
- address — VARCHAR
- registered_date — DATE
order
- hold_id — VARCHAR — Primary key — NOT NULL
- receiver — VARCHAR — Foreign key → user_wallet.address — NOT NULL
- secret — VARCHAR
- amount — INTEGER
- token_address — VARCHAR — Foreign key → security_token.address — NOT NULL
- registered_date — TIMESTAMP
- user_id — VARCHAR — Foreign key → portal_user.id — NOT NULL
- notary — VARCHAR
- dt_amount — INTEGER
- status — VARCHAR
- hold_transaction_id — VARCHAR
- execute_transaction_id — VARCHAR
- cretificate — VARCHAR
- release_date — TIMESTAMP
partition
- name — VARCHAR — Primary key — NOT NULL
- address — VARCHAR
portal_user
- id — VARCHAR(100) — Primary key — NOT NULL
- password — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- login_fail_count — BIGINT
- last_logged_in — TIMESTAMP
- last_pw_change — TIMESTAMP
- registered_date — TIMESTAMP
- update_date — TIMESTAMP
- roleId — INTEGER — Foreign key → role.id — NOT NULL
- statusId — INTEGER — Foreign key → status.id
- company — VARCHAR — NOT NULL
- kyc — BOOLEAN
role
- id — INTEGER — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
security_token
- address — VARCHAR — Primary key — NOT NULL
- symbol — VARCHAR — NOT NULL
- standard — VARCHAR
- registered_date — DATE
- granularity — INTEGER
status
- id — INTEGER — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
super_user
- id — VARCHAR — Primary key — NOT NULL
- registered_date — DATE
- address — VARCHAR
user_wallet
- address — VARCHAR — Primary key — NOT NULL
- user_id — VARCHAR — Foreign key → portal_user.id — NOT NULL
- registered_date — TIMESTAMP — NOT NULL
- default — BOOLEAN