publishig tokenize

Tables (8)

dtc_category (Untitled5)

  • id (Key) — INT — Primary key — NOT NULL
  • cat_cd (Field) — VARCHAR(20)
  • cat_name (Field2) — VARCHAR(255)
  • cat_name_en (Field3) — VARCHAR(255)
  • is_root (Field4) — INT
  • delete_flag (Field5) — VARCHAR(10)

dtc_category_repltion (Untitled6)

  • id (Field) — INT
  • depth (Field2) — INT
  • delete_flag (Field3) — VARCHAR(10)
  • ancestor_id (Key) — INT — Foreign key → dtc_category.id — NOT NULL
  • descendant_id (Key2) — INT — Foreign key → dtc_category.id — NOT NULL

dtc_class (Untitled4)

  • id — INT — Primary key — NOT NULL
  • class_cd (Field) — VARCHAR(20)
  • class_name (Field2) — VARCHAR(255)
  • class_name_en (Field3) — VARCHAR(255)
  • delete_flag (Field4) — VARCHAR(10)

dtc_type (Untitled3)

  • id — INT — Primary key — NOT NULL
  • type_cd (Field) — VARCHAR(20)
  • publishing_type (Field2) — VARCHAR(255)
  • publishing_type_en (Field3) — VARCHAR(255)
  • delete_flag (Field4) — VARCHAR(10)

dth_ledger (Untitled)

  • id — INT — Primary key — NOT NULL
  • user_id — INT
  • tr_type — VARCHAR(20)
  • balance_type (Field) — VARCHAR(20)
  • tr_amt (Field2) — NUMERIC(31,18)
  • remarks (Field4) — VARCHAR(255)
  • created_at (Field3) — DATETIME

dtm_contract (BOOK)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • writer (Field2) — VARCHAR(50)
  • delete_flag (Field3) — VARCHAR(10)
  • type_id (id) — INT — Foreign key → dtc_type.id — NOT NULL
  • class_id (id2) — INT — Foreign key → dtc_class.id — NOT NULL
  • category_id (Key2) — INT — Foreign key → dtc_category.id — NOT NULL
  • year (Field4) — VARCHAR(8)
  • symbol (Field5) — VARCHAR(20)
  • description (Field6) — VARCHAR(4096)
  • publisher_id (Key3) — INT — Foreign key → dtm_publisher.id — NOT NULL
  • created_at (Field7) — DATETIME
  • book_price (Field8) — INT
  • token_total (Field9) — INT
  • token_notsold (Field10) — INT
  • token_image (Field11) — VARCHAR(1024)
  • pc_contract_id (Field12) — INT
  • token_wallet (Field13) — VARCHAR(255)

dtm_contract_detail (Untitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • contract_id (Key2) — INT — Foreign key → dtm_contract.id — NOT NULL
  • name (Field) — VARCHAR(255)
  • file_url (Field2) — VARCHAR(1024)
  • delete_flag (Field3) — VARCHAR(10)
  • created_at (Field4) — DATETIME

dtm_publisher (Untitled7)

  • id (Key) — INT — Primary key — NOT NULL
  • publisher_name (Field) — VARCHAR(255)
  • publisher_name_en (Field2) — VARCHAR(255)
  • delete_flag (Field3) — VARCHAR(10)
  • created_at (Field4) — DATETIME