Database Constraints | Create Table MYSQL

-- create table Order
CREATE TABLE `order` (
  `order_id` char(15),
  `order_date` datetime,
  `order_payment` int(11),
  `user_id` char(5)
);

-- create table Order Detail
CREATE TABLE `order_detail` (
  `order_detail_id` char(19),
  `order_detail_amount` int(11),
  `id_product` char(4),
  `order_id` char(15)
);

-- create table Product
CREATE TABLE `product` (
  `product_id` char(4),
  `product_name` varchar(255),
  `product_price` int(11),
  `product_amount` int(11)
);

-- create table User
CREATE TABLE `user` (
  `user_id` char(5),
  `user_name` varchar(255),
  `user_phone` char(20),
  `user_email` varchar(255),
  `user_password` varchar(255),
  `user_balance` int(12),
  `user_status` enum('unvalid','validated','disabled'),
  `user_role` enum('customer','admin','cashier')
);