baas-be

Tables (14)

ACCOUNTS

  • ACCOUNT_ID — bigint(20) unsigned — Primary key — NOT NULL

CHAINS

  • CHAIN_ID — varchar(20) — Primary key — NOT NULL
  • ACCOUNT_ID — bigint(20) unsigned — Foreign key → ACCOUNTS.ACCOUNT_ID — NOT NULL
  • NAME — varchar(256)
  • TYPE — enum('CONSORTIUM', 'TRIAL', 'STARTER', 'BASIC') — NOT NULL — 'BASIC'
  • ENGINE — enum('LPOA', 'ETHEREUM', 'HYPERLEDGER', 'HYPERLEDGER-FABRIC') — NOT NULL — 'HYPERLEDGER-FABRIC'
  • STATUS — enum('UNKNOWN', 'SCREENING', 'WAITABLE', 'WAIT', 'REJECT', 'PENDING', 'CREATING', 'RUNNING', 'PAUSING', 'PAUSED', 'RESUMING', 'STOP', 'ERROR', 'DELETING', 'DESTROYED') — NOT NULL
  • CREATED_AT — datetime — NOT NULL
  • UPDATED_AT — datetime — NOT NULL
  • PAUSED_AT — datetime
  • DESTROYED_AT (DESTRYOED_AT) — datetime

HLF_CHAINCODES

  • CHAINCODE_ID — bigint(20) unsigned — Primary key — NOT NULL
  • CHAIN_ID — varchar(20) — Foreign key → CHAINS.CHAIN_ID — NOT NULL
  • NAME — varchar(256) — NOT NULL
  • DESCRIPTION — longtext
  • VERSION — varchar(64) — NOT NULL
  • FILENAME — varchar(256) — NOT NULL
  • UPLOADED_KEY — varchar(512) — NOT NULL
  • UPDATED_AT — datetime — NOT NULL
  • CREATED_AT — datetime — NOT NULL

HLF_CHAINCODE_DEFINITIONS

  • DEFINITION_ID — bigint(20) unsigned — Primary key — NOT NULL
  • ORGANIZATION_ID — bigint(20) unsigned — Foreign key → HLF_ORGANIZATIONS.ORGANIZATION_ID — NOT NULL
  • CHANNEL_ID — bigint(20) unsigned — Foreign key → HLF_CHANNELS.CHANNEL_ID — NOT NULL
  • ACCOUNT_ID — bigint(20) unsigned — Foreign key → ACCOUNTS.ACCOUNT_ID — NOT NULL — 생성한 사람
  • PACKAGE_ID — varchar(256) — NOT NULL
  • ARGS — longtext — NOT NULL — 이니셜 파라미터
  • SEQUENCE_NUMBER — bigint(20) unsigned — NOT NULL — PACKAGE_ID, ORGANIZATION_ID, CHANNEL_ID, SEQUENCE_NUMBER 유니크
  • STATUS — enum('WAIT','CREATING','CREATED','CHECKING','COMMITTABLE','COMMITTING','COMMITTED','INSTANTIATING','INSTANTIATED','ERROR') — NOT NULL
  • MESSAGE — varchar(256) — 에러 메시지
  • CREATED_AT — datetime — NOT NULL

HLF_CHAINCODE_INSTALL_REQUESTS

  • REQUEST_ID — bigint(20) unsigned — Primary key — NOT NULL
  • ACCOUNT_ID — bigint(20) unsigned — Foreign key → ACCOUNTS.ACCOUNT_ID — NOT NULL — 생성한 사람
  • PEER_ID — bigint(20) unsigned — Foreign key → HLF_ORGANIZATION_PEERS.PEER_ID — NOT NULL
  • CHAINCODE_ID — bigint(20) unsigned — Foreign key → HLF_CHAINCODES.CHAINCODE_ID — NOT NULL
  • STATUS — enum('WAIT','PACKAGING','PACKAGED','INSTALLING','INSTALLED','ERROR') — NOT NULL
  • PACKAGE_ID — varchar(256) — 인스톨 성공시 생성된 패키지 아이디
  • MESSAGE — varchar(256) — 에러 메시지
  • CREATED_AT — datetime — NOT NULL

HLF_CHANNELS

  • CHANNEL_ID — bigint(20) unsigned — Primary key — NOT NULL
  • CHAIN_ID — varchar(20) — Foreign key → CHAINS.CHAIN_ID — NOT NULL
  • NAME — varchar(256) — NOT NULL
  • UPDATED_AT — datetime — NOT NULL
  • CREATED_AT — datetime — NOT NULL

HLF_CHANNELS_PEERS (HLF_CHANNEL_PEERS)

  • CHANNEL_ID — bigint(20) unsigned — Foreign key → HLF_CHANNELS.CHANNEL_ID — NOT NULL
  • PEER_ID — bigint(20) unsigned — Foreign key → HLF_ORGANIZATION_PEERS.PEER_ID — NOT NULL
  • CREATED_AT — datetime — NOT NULL

HLF_ORGANIZATIONS

  • ORGANIZATION_ID — bigint(20) unsigned — Primary key — NOT NULL
  • CHAIN_ID — varchar(20) — Foreign key → CHAINS.CHAIN_ID — NOT NULL
  • NAME — varchar(256) — NOT NULL
  • DOMAIN_NAME — varchar(256) — NOT NULL
  • UPDATED_AT — datetime — NOT NULL
  • CREATED_AT — datetime — NOT NULL

HLF_ORGANIZATION_CAS

  • CA_ID — bigint(20) unsigned — Primary key — NOT NULL
  • ORGANIZATION_ID — bigint(20) unsigned — Foreign key → HLF_ORGANIZATIONS.ORGANIZATION_ID — NOT NULL
  • NAME — varchar(256) — NOT NULL
  • DOMAIN_NAME — varchar(256) — NOT NULL
  • STATUS — enum('WAIT','CREATING','RUNNING','PAUSING','PAUSED','RESUMING','DEPLOYED', 'ERROR') — NOT NULL
  • UPDATED_AT — datetime — NOT NULL
  • CREATED_AT — datetime — NOT NULL

HLF_ORGANIZATION_MEMBERS

  • MEMBER_ID — bigint(20) unsigned — Primary key — NOT NULL
  • ORGANIZATION_ID — bigint(20) unsigned — Foreign key → HLF_ORGANIZATIONS.ORGANIZATION_ID — NOT NULL
  • ACCOUNT_ID — bigint(20) unsigned — Foreign key → ACCOUNTS.ACCOUNT_ID — NOT NULL
  • ENROLLMENT_ID — varchar(256) — NOT NULL
  • ROLE — enum['ORG_ADMIN','CA_ADMIN','MEMBER'] — NOT NULL
  • UPDATED_AT — NOT NULL
  • CREATED_AT — datetime — NOT NULL

HLF_ORGANIZATION_ORDERERS

  • ORDERER_ID — bigint(20) unsigned — Primary key — NOT NULL
  • ORGANIZATION_ID — bigint(20) unsigned — Foreign key → HLF_ORGANIZATIONS.ORGANIZATION_ID — NOT NULL
  • NAME — varchar(256) — NOT NULL
  • DOMAIN_NAME — varchar(256) — NOT NULL
  • STATUS — enum('WAIT','CREATING','RUNNING','PAUSING','PAUSED','RESUMING','DEPLOYED','ERROR') — NOT NULL
  • UPDATED_AT — datetime — NOT NULL
  • CREATED_AT — datetime — NOT NULL

HLF_ORGANIZATION_PEERS

  • PEER_ID — bigint(20) unsigned — Primary key — NOT NULL
  • ORGANIZATION_ID — bigint(20) unsigned — Foreign key → HLF_ORGANIZATIONS.ORGANIZATION_ID — NOT NULL
  • NAME — varchar(256) — NOT NULL
  • DOMAIN_NAME — varchar(256) — NOT NULL
  • STATUS — enum('WAIT','CREATING','RUNNING','PAUSING','PAUSED','RESUMING','DEPLOYED','ERROR') — NOT NULL
  • UPDATED_AT — datetime — NOT NULL
  • CREATED_AT — datetime — NOT NULL

HLF_ORGS_PRIVILEGES (PRIVILEGES_FABRIC_ORG)

  • TYPE — enum['ORG_VIEW'] — Primary key — NOT NULL
  • ORGANIZATION_ID — bigint(20) unsigned — Foreign key → HLF_ORGANIZATIONS.ORGANIZATION_ID — NOT NULL
  • ACCOUNT_ID — bigint(20) unsigned — Foreign key → ACCOUNTS.ACCOUNT_ID — NOT NULL
  • CREATED_AT — datetime — NOT NULL

PRIVILEGES_CHAIN

  • TYPE — varchar(32) — Primary key — NOT NULL — 'CHAIN_VIEW'
  • CHAIN_ID — varchar(20) — Foreign key → CHAINS.CHAIN_ID — NOT NULL
  • ACCOUNT_ID — bigint(20) unsigned — Foreign key → ACCOUNTS.ACCOUNT_ID — NOT NULL
  • STATUS — enum('NA','WAIT','REQUESTING','REQUESTED','DONE','ERROR') — NOT NULL — 'NA'
  • CREATED_AT — datetime — NOT NULL