Table: asset

[tloriato]

Reference: #6

Original Abe:

DROP TABLE IF EXISTS `asset`;

CREATE TABLE `asset` (
  `asset_id` decimal(10,0) NOT NULL,
  `tx_id` decimal(26,0) NOT NULL,
  `chain_id` decimal(10,0) NOT NULL,
  `name` varchar(255) NOT NULL,
  `multiplier` decimal(10,0) NOT NULL,
  `issue_qty` decimal(30,0) NOT NULL,
  `prefix` decimal(10,0) NOT NULL,
  PRIMARY KEY (`asset_id`),
  UNIQUE KEY `tx_id` (`tx_id`),
  KEY `chain_id` (`chain_id`),
  CONSTRAINT `asset_ibfk_1` FOREIGN KEY (`tx_id`) REFERENCES `tx` (`tx_id`),
  CONSTRAINT `asset_ibfk_2` FOREIGN KEY (`chain_id`) REFERENCES `chain` (`chain_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Sequelize:

DROP TABLE IF EXISTS `asset`;

CREATE TABLE `asset` (
  `asset_id` double NOT NULL,
  `tx_id` double NOT NULL,
  `chain_id` double NOT NULL,
  `name` varchar(255) NOT NULL,
  `multiplier` double NOT NULL,
  `issue_qty` double NOT NULL,
  `prefix` double NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`asset_id`),
  KEY `tx_id` (`tx_id`),
  KEY `chain_id` (`chain_id`),
  CONSTRAINT `asset_ibfk_1` FOREIGN KEY (`tx_id`) REFERENCES `tx` (`tx_id`),
  CONSTRAINT `asset_ibfk_2` FOREIGN KEY (`chain_id`) REFERENCES `chain` (`chain_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;