Mysql Demo

docker-command.txt

docker run --name mysqldb -e MYSQL_ROOT_PASSWORD=password -p 3306:3306 -d mysql

ticket-detail.md

TicketDetail Tables

สร้าง table ticketDetailTable โดยมี column ดังนี้

column	type
id	varchar(32) pk
ticketId	varchar(32) fk -> tickerTables
detail	vachar(512)
attachment	json
createdAt	DateTime default CURRENT_TIMESTAMP
updatedAt	Datetime default CURRENT_TIMESTAMP

ticketTables.sql

create table opertaion_tickets.ticketTables
(
  id        varchar(32)                        not null
    primary key,
  title     varchar(256)                       not null,
  createdAt datetime default CURRENT_TIMESTAMP null,
  updatedAt datetime default CURRENT_TIMESTAMP null
);