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