[sql] supa_mst_db

Viewer

copydownloadembedprintName: supa_mst_db
  1. CREATE TABLE `mst_skatepark` (
  2.         `id` VARCHAR(10) NOT NULL,
  3.         `name` VARCHAR(30) NOT NULL,
  4.         `use_fee` BOOLEAN NOT NULL,
  5.         `fee_value` DECIMAL(10),
  6.         `usage_option` VARCHAR(10),
  7.         `open_hour` TIMESTAMP,
  8.         `closed_hour` TIMESTAMP,
  9.         `location_is_still_open` BOOLEAN,
  10.         `mst_location_id` VARCHAR(10),
  11.         `is_active` BOOLEAN NOT NULL,
  12.         `created_by_id` VARCHAR(10) NOT NULL,
  13.         `updated_by_id` VARCHAR(10),
  14.         `created_at` TIMESTAMP,
  15.         `updated_at` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  16.         PRIMARY KEY (`id`)
  17. ) ENGINE=InnoDB;

Editor

You can edit this paste and save as new:


File Description
  • supa_mst_db
  • Paste Code
  • 21 Oct-2020
  • 520 Bytes
You can Share it: