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