SCON
Tables (25)
Action Category (ACTION_CATEGORIES)
- ID — NUMBER — Primary key — NOT NULL
- NAME (ACTION_NAME) — VARCHAR2(255)
Action Detail (ACTION_DETAILS)
- ID — NUMBER — Primary key — NOT NULL
- CONTENT (CONTEXT) — VARCHAR2(1000)
- SUB TYPE ID (SUB_TYPE_ID) — NUMBER — Foreign key → Action Sub Type.ID — NOT NULL
Action Main Type (ACTION_MAIN_TYPES)
- ID — NUMBER — Primary key — NOT NULL
- NAME (MAIN_TYPE_NAME) — VARCHAR2(255)
- CATEGORY ID (CATEGORY_ID) — NUMBER — Foreign key → Action Category.ID — NOT NULL
Action Sub Type (ACTION_SUB_TYPES)
- ID — NUMBER — Primary key — NOT NULL
- TITLE — VARCHAR2(255)
- TYPE — VARCHAR2(255)
- MAIN TYPE ID (MAIN_TYPE_ID) — NUMBER — Foreign key → Action Main Type.ID — NOT NULL
Asset (ASSET)
- ID — NUMBER — Primary key — NOT NULL
- NAME (ALIAS) — VARCHAR2(255)
- PROVIDER — VARCHAR2(255)
- ACCOUNT/ADDRESS (ADDRESS) — VARCHAR2(255)
- WALLET (SUBTYPE) — VARCHAR2(255)
- IS_BLOCK_CHAIN (TYPE) — NUMBER
- USER ID (USER_ID) — NUMBER — Foreign key → User.ID — NOT NULL
Condition (CONDITION)
- ID — NUMBER — Primary key — NOT NULL — 아직 구현되지 않음.
- OPERATIONTYPE — CHAR(1)
- REQUIRECOUNT — NUMBER(38,0)
- TIMESTAMP — TIMESTAMP(0)
- CONTRACTID — NUMBER — Foreign key → Contract.ID — NOT NULL — FK로 설정해야 적합하지만, SAS에서 Service가 종료되기 전에 해당 데이터가 create되지 않는 이슈가 있어서 FK로 설정 시 오류 발생 -> 일단 FK 제거해 놓은 상태
Condition Category (CONDITION_CATEGORIES)
- ID — NUMBER — Primary key — NOT NULL
- NAME (CONDITION_NAME) — VARCHAR2(255)
- TEMPLATE TYPE ID (TEMPLATE_TYPE_ID) — NUMBER — Foreign key → Template Sub Type.ID — NOT NULL
Condition Detail (CONDITION_DETAILS)
- ID — NUMBER — Primary key — NOT NULL
- CONTENT (CONTEXT) — VARCHAR2(1000)
- SUB TYPE ID (SUB_TYPE_ID) — NUMBER — Foreign key → Condition Sub Type.ID — NOT NULL
Condition Main Type (CONDITION_MAIN_TYPES)
- ID — NUMBER — Primary key — NOT NULL
- NAME (MAIN_TYPE_NAME) — VARCHAR2(255)
- PRODUCT ID (PARENT_ID) — NUMBER — Foreign key → Condition Product.ID — NOT NULL
Condition Mid Type (CONDITION_MID_TYPES)
- ID — NUMBER — Primary key — NOT NULL
- NAME (MID_TYPE_NAME) — VARCHAR2(255)
- MAIN TYPE ID (MAIN_TYPE_ID) — NUMBER — Foreign key → Condition Main Type.ID — NOT NULL
Condition Product (CONDITION_PRODUCT)
- ID — NUMBER — Primary key — NOT NULL
- NAME (PRODUCT_NAME) — VARCHAR2(255)
- CATEGORY ID (CATEGORY_ID) — NUMBER — Foreign key → Condition Category.ID — NOT NULL
Condition Sub Type (CONDITION_SUB_TYPES)
- ID — NUMBER — Primary key — NOT NULL
- TITLE — VARCHAR2(255)
- TYPE — VARCHAR2(255)
- MID TYPE ID (MID_TYPE_ID) — NUMBER — Foreign key → Condition Mid Type.ID — NOT NULL
Contract (CONTRACT)
- ID — NUMBER — Primary key — NOT NULL
- NAME (CONTRACT_NAME) — VARCHAR2(255)
- VALID DATE (VALID_DATE) — VARCHAR2(255) — 유효 계약 기간
- CREATED DATE (CREATED_DATE) — TIMESTAMP(0) — 계약 생성일
- UPDATED DATE (UPDATED_DATE) — TIMESTAMP(0) — 계약 수정일
- DELETED_DATE — TIMESTAMP(0)
- IS_DELETED — NUMBER
- SENDER SIGNATURE (SENDER_SIGNATURE) — NUMBER
- RECIPIENT SIGNATURE (RECIPIENT_SIGNATURE) — NUMBER
- 스마트컨트랙트주소 (CONTRACT_ADDRESS) — VARCHAR2(255) — UNIQ
- SENDER ID (SENDER_ID) — NUMBER — Foreign key → User.ID — NOT NULL
- RECIPIENT ID (RECIPIENT_ID) — NUMBER — Foreign key → User.ID — NOT NULL
- STATUS ID (CONTRACT_STATUS_ID) — NUMBER — Foreign key → Contract Status Detail.ID — NOT NULL
Contract Status Category (CONTRACT_STATUS_CATEGORY)
- ID — NUMBER — Primary key — NOT NULL
- NAME (CATEGORY_NAME) — VARCHAR2(255)
Contract Status Detail (CONTRACT_STATUS_DETAIL)
- ID — NUMBER — Primary key — NOT NULL
- NAME (STATUS_NAME) — VARCHAR2(255)
- CATEGORY ID (CATEGORY_ID) — NUMBER — Foreign key → Contract Status Category.ID — NOT NULL
History Log (SCON_LOG)
- ID — NUMBER — Primary key — NOT NULL
- EVENT NAME (EVENT_NAME) — VARCHAR2(255)
- VALUE — NUMBER
- TRANSACTION FEE (TRANSACTION_FEE) — NUMBER
- CURRENCY — VARCHAR2(255)
- DATE (CREATED_DATE) — VARCHAR2(255) — UNIXTIMESTAMP
- CONTRACT ADDRESS — VARCHAR2(255) — Foreign key → Contract.ID — NOT NULL
- FROM ADDRESS (FROM_ADDRESS) — NUMBER — Foreign key → Asset.ID — NOT NULL
- TO ADDRESS (TO_ADDRESS) — NUMBER — Foreign key → Asset.ID — NOT NULL
Image (IMAGE)
- ID — NUMBER — Primary key — NOT NULL
- IMAGE STR (IMAGE_STR) — VARCHAR2(65000)
- TYPE — CHAR(1)
- TITLE — VARCHAR2(255)
- USER ID (USER_ID) — NUMBER — Foreign key → User.ID — NOT NULL
Input Value (INPUT_VALUE)
- ID — NUMBER — Primary key — NOT NULL
- INPUT VALUE (INPUT_VALUE) — VARCHAR2(1000)
- CONTRACT ID (CONTRACT_ID) — NUMBER — Foreign key → Contract.ID — NOT NULL
- TEMPLATE ID (TEMPLATE_ID) — NUMBER — Foreign key → Template Sub Type.ID — NOT NULL
- CONDITION ID (CONDITION_ID) — NUMBER — Foreign key → Condition Mid Type.ID — NOT NULL
- ACTION ID (ACTION_ID) — NUMBER — Foreign key → Action Main Type.ID — NOT NULL
Scheduling (SCHEDULE)
- UUID — VARCHAR2(255) — Primary key — NOT NULL — PK를 NUMBER로 변경해야되지 않는지 고민중.
- TIME — TIMESTAMP(0) — UNIXTIMESTAMP
- IS_BLOCKCHAIN — NUMBER
- IS_DELETED — NUMBER
- CONTRACTID (CONTRACT_ID) — NUMBER — Foreign key → Contract.ID — NOT NULL
- CONDITION ID (CONDITION_ID) — NUMBER — Foreign key → Condition.ID — NOT NULL — 아직 구현되지 않음.
Template Action Relation (Template_Action_Relation)
- TEMPLATE ID (TEMPLATE_ID) — NUMBER — Foreign key → Template Sub Type.ID — NOT NULL
- ACTION ID (ACTION_ID) — NUMBER — Foreign key → Action Category.ID — NOT NULL
Template Category (CONTRACT_CATEGORIES)
- ID — NUMBER — Primary key — NOT NULL
- NAME (CATEGORY_NAME) — VARCHAR2(255)
Template Detail (CONTRACT_DETAILS)
- ID — NUMBER — Primary key — NOT NULL
- CONTENT (DETAIL_DESCRIPTION) — VARCHAR2(1000)
- TYPE ID (TYPE_ID) — NUMBER — Foreign key → Template Sub Type.ID — NOT NULL
Template Main Type (CONTRACT_MAIN_TYPES)
- ID — NUMBER — Primary key — NOT NULL
- MAIN_TYPE_NAME — VARCHAR2(255)
- CATEGORY ID (CATEGORY_ID) — NUMBER — Foreign key → Template Category.ID — NOT NULL
Template Sub Type (CONTRACT_SUB_TYPES)
- ID — NUMBER — Primary key — NOT NULL
- NAME (SUB_TYPE_NAME) — VARCHAR2(255)
- MAIN TYPE ID (MAIN_TYPE_ID) — NUMBER — Foreign key → Template Main Type.ID — NOT NULL
User (SCON_USER)
- ID — NUMBER — Primary key — NOT NULL
- USER ID (USER_ID) — VARCHAR2(255)
- PASSWORD — VARCHAR2(64) — 일단 SHA256을 사용한다고 가정하고 해시값을 저장할 64자리로 설정하였음.
- NAME — VARCHAR2(255)