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)