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