function/prompt/prompt_create_table.py

PROMPT_TABLE = """
Danh sách bảng: ['absence_request', 'cart', 'cart_group', 'cart_item', 'cart_item_group', 'category', 'category_translation', 'contact', 'favourite', 'favourite_item', 'group_order_members', 'group_orders', 'map_directions', 'notification', 'order_item', 'orders', 'otp', 'payments', 'payments_group', 'post', 'post_translation', 'price_history', 'product', 'product_translation', 'product_variants', 'review', 'shipment', 'shipment_group', 'shipper_attendance', 'shipper_commission_detail', 'shipper_salary_summary', 'step_details', 'token', 'user', 'user_chat', 'user_coin', 'user_voucher', 'voucher']

--- CREATE TABLE `absence_request` ---
CREATE TABLE "absence_request" (
  "request_id" int NOT NULL AUTO_INCREMENT,
  "end_date" datetime DEFAULT NULL,
  "reason" text COLLATE utf8mb4_general_ci NOT NULL,
  "start_date" datetime DEFAULT NULL,
  "status" enum('APPROVED','REJECTED','WAITING') COLLATE utf8mb4_general_ci NOT NULL,
  "user_id" int NOT NULL,
  PRIMARY KEY ("request_id"),
  KEY "FK7xuwoeagvnchyta5oous76oo1" ("user_id"),
  CONSTRAINT "FK7xuwoeagvnchyta5oous76oo1" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `cart` ---
CREATE TABLE "cart" (
  "cart_id" int NOT NULL AUTO_INCREMENT,
  "status" enum('COMPLETED','NEW','RESTORE','COMPLETED_PAUSE') COLLATE utf8mb4_general_ci DEFAULT NULL,
  "total_price" double DEFAULT NULL,
  "total_product" int DEFAULT NULL,
  "user_id" int NOT NULL,
  PRIMARY KEY ("cart_id"),
  KEY "FKl70asp4l4w0jmbm1tqyofho4o" ("user_id"),
  CONSTRAINT "FKl70asp4l4w0jmbm1tqyofho4o" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `cart_group` ---
CREATE TABLE "cart_group" (
  "cart_id" int NOT NULL AUTO_INCREMENT,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_updated" datetime DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "total_price" double DEFAULT NULL,
  "total_product" int DEFAULT NULL,
  "member_id" int NOT NULL,
  "user_id" int NOT NULL,
  PRIMARY KEY ("cart_id"),
  UNIQUE KEY "UKpq71nxpdtgr7m079b1whec06q" ("member_id"),
  KEY "FKiubh7si2qpkohrgookkqb0lgu" ("user_id"),
  CONSTRAINT "FKiubh7si2qpkohrgookkqb0lgu" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id"),
  CONSTRAINT "FKrqau0ohjusewslefosxagi5bg" FOREIGN KEY ("member_id") REFERENCES "group_order_members" ("member_id")
)

--- CREATE TABLE `cart_item` ---
CREATE TABLE "cart_item" (
  "cart_item_id" int NOT NULL AUTO_INCREMENT,
  "quantity" int DEFAULT NULL,
  "total_price" double DEFAULT NULL,
  "cart_id" int NOT NULL,
  "pro_id" int DEFAULT NULL,
  "size" enum('L','M','S') COLLATE utf8mb4_general_ci DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "note" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY ("cart_item_id"),
  KEY "FK1uobyhgl1wvgt1jpccia8xxs3" ("cart_id"),
  KEY "FKnn3h5nbk6wn36ndrt86ybfpy1" ("pro_id","size"),
  CONSTRAINT "FK1uobyhgl1wvgt1jpccia8xxs3" FOREIGN KEY ("cart_id") REFERENCES "cart" ("cart_id"),
  CONSTRAINT "FKnn3h5nbk6wn36ndrt86ybfpy1" FOREIGN KEY ("pro_id", "size") REFERENCES "product_variants" ("pro_id", "size")
)

--- CREATE TABLE `cart_item_group` ---
CREATE TABLE "cart_item_group" (
  "cart_item_id" int NOT NULL AUTO_INCREMENT,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_updated" datetime DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "item_price" double DEFAULT NULL,
  "note" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "quantity" int DEFAULT NULL,
  "total_price" double DEFAULT NULL,
  "cart_id" int NOT NULL,
  "pro_id" int DEFAULT NULL,
  "size" enum('L','M','S') COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY ("cart_item_id"),
  KEY "FKqw9wot6jc4p5hwiwlhtb6jbog" ("cart_id"),
  KEY "FKtfldbunlels28kg10rft89cv" ("pro_id","size"),
  CONSTRAINT "FKqw9wot6jc4p5hwiwlhtb6jbog" FOREIGN KEY ("cart_id") REFERENCES "cart_group" ("cart_id"),
  CONSTRAINT "FKtfldbunlels28kg10rft89cv" FOREIGN KEY ("pro_id", "size") REFERENCES "product_variants" ("pro_id", "size")
)

--- CREATE TABLE `category` ---
CREATE TABLE "category" (
  "cate_id" int NOT NULL AUTO_INCREMENT,
  "cate_img" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "cate_name" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_updated" datetime DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  PRIMARY KEY ("cate_id")
)

--- CREATE TABLE `category_translation` ---
CREATE TABLE "category_translation" (
  "cate_trans_id" int NOT NULL AUTO_INCREMENT,
  "cate_name" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_updated" datetime DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "language_code" enum('EN','VN') COLLATE utf8mb4_general_ci DEFAULT NULL,
  "cate_id" int DEFAULT NULL,
  PRIMARY KEY ("cate_trans_id"),
  KEY "FKqfx54ldadyi0o390j5w0xgpe1" ("cate_id"),
  CONSTRAINT "FKqfx54ldadyi0o390j5w0xgpe1" FOREIGN KEY ("cate_id") REFERENCES "category" ("cate_id")
)

--- CREATE TABLE `contact` ---
CREATE TABLE "contact" (
  "contact_id" bigint NOT NULL AUTO_INCREMENT,
  "create_date" datetime NOT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "description" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "email" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "full_name" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "phone_number" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "status" enum('COMPLETED','WAITING') COLLATE utf8mb4_general_ci NOT NULL,
  "date_updated" datetime DEFAULT NULL,
  "user_id" int DEFAULT NULL,
  PRIMARY KEY ("contact_id")
)

--- CREATE TABLE `favourite` ---
CREATE TABLE "favourite" (
  "fav_id" int NOT NULL AUTO_INCREMENT,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_updated" datetime DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "user_id" int NOT NULL,
  PRIMARY KEY ("fav_id"),
  UNIQUE KEY "UKtn0yetnb6bftwuygek6071cs4" ("user_id"),
  CONSTRAINT "FK83lccer6s8bgj5jgjwan5eipk" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `favourite_item` ---
CREATE TABLE "favourite_item" (
  "fav_item_id" int NOT NULL AUTO_INCREMENT,
  "fav_id" int NOT NULL,
  "pro_id" int DEFAULT NULL,
  "size" enum('L','M','S') COLLATE utf8mb4_general_ci DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  PRIMARY KEY ("fav_item_id"),
  KEY "FKbug2wkmy00j351syuegu20fnr" ("fav_id"),
  KEY "FK2xoaduosag75t69tclidxxgfq" ("pro_id","size"),
  CONSTRAINT "FK2xoaduosag75t69tclidxxgfq" FOREIGN KEY ("pro_id", "size") REFERENCES "product_variants" ("pro_id", "size"),
  CONSTRAINT "FKbug2wkmy00j351syuegu20fnr" FOREIGN KEY ("fav_id") REFERENCES "favourite" ("fav_id")
)

--- CREATE TABLE `group_order_members` ---
CREATE TABLE "group_order_members" (
  "member_id" int NOT NULL AUTO_INCREMENT,
  "amount" double DEFAULT NULL,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_updated" datetime DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "is_leader" bit(1) NOT NULL,
  "is_paid" bit(1) NOT NULL,
  "note" text COLLATE utf8mb4_general_ci,
  "quantity" int DEFAULT NULL,
  "status" enum('CANCELED','CHECKOUT','COMPLETED','CREATED','SHOPPING') COLLATE utf8mb4_general_ci NOT NULL,
  "type_payment" enum('CASH','MOMO','NONE','PAYOS','VNPAY','ZALO') COLLATE utf8mb4_general_ci NOT NULL,
  "cart_id" int DEFAULT NULL,
  "group_order_id" int NOT NULL,
  "user_id" int NOT NULL,
  "is_deleted_leader" bit(1) DEFAULT NULL,
  PRIMARY KEY ("member_id"),
  KEY "FKjebhpyrg58enl703ofk7fx57j" ("cart_id"),
  KEY "FK3dkn2632hygabsmi5fldast6t" ("group_order_id"),
  KEY "FK41od466att9w31qfd5k1lm85d" ("user_id"),
  CONSTRAINT "FK3dkn2632hygabsmi5fldast6t" FOREIGN KEY ("group_order_id") REFERENCES "group_orders" ("group_order_id"),
  CONSTRAINT "FK41od466att9w31qfd5k1lm85d" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id"),
  CONSTRAINT "FKjebhpyrg58enl703ofk7fx57j" FOREIGN KEY ("cart_id") REFERENCES "cart_group" ("cart_id")
)

--- CREATE TABLE `group_orders` ---
CREATE TABLE "group_orders" (
  "group_order_id" int NOT NULL AUTO_INCREMENT,
  "address" text COLLATE utf8mb4_general_ci,
  "code" varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_updated" datetime DEFAULT NULL,
  "deadline_payment" datetime DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "is_flexible_payment" bit(1) DEFAULT NULL,
  "link" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "name_group" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "note" text COLLATE utf8mb4_general_ci,
  "order_date" datetime NOT NULL,
  "status" enum('CANCELED','CHECKOUT','COMPLETED','CREATED','SHOPPING') COLLATE utf8mb4_general_ci NOT NULL,
  "total_price" double NOT NULL,
  "total_quantity" double NOT NULL,
  "type_bill" enum('PAY_FOR_ALL','SPLIT_BILL_WITH_ALL') COLLATE utf8mb4_general_ci NOT NULL,
  "type_payment" enum('CASH','MOMO','NONE','PAYOS','VNPAY','ZALO') COLLATE utf8mb4_general_ci NOT NULL,
  "user_id" int NOT NULL,
  PRIMARY KEY ("group_order_id"),
  UNIQUE KEY "UK35u679oel6xd7ey4unhh5v9oq" ("code"),
  UNIQUE KEY "UK401ngfww9iugp63r17wlbk3n" ("link"),
  KEY "FKffxlnnw76ajjwyx14h1e4lb9g" ("user_id"),
  CONSTRAINT "FKffxlnnw76ajjwyx14h1e4lb9g" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `map_directions` ---
CREATE TABLE "map_directions" (
  "map_direction_id" bigint NOT NULL AUTO_INCREMENT,
  "created_at" datetime DEFAULT NULL,
  "deleted_at" datetime DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "latitude_end" double DEFAULT NULL,
  "latitude_start" double DEFAULT NULL,
  "longitude_end" double DEFAULT NULL,
  "longitude_start" double DEFAULT NULL,
  "overview_polyline" text COLLATE utf8mb4_general_ci,
  "shipment_id" int DEFAULT NULL,
  "shipment_group_id" int DEFAULT NULL,
  PRIMARY KEY ("map_direction_id"),
  UNIQUE KEY "UKmu9kycqumup9hqbby5eodro2h" ("shipment_id"),
  UNIQUE KEY "UKm7yn0emg8qoyg52u7hr23d0kp" ("shipment_group_id"),
  CONSTRAINT "FKpbu0kubi0l2xxq1vwcgt897l6" FOREIGN KEY ("shipment_group_id") REFERENCES "shipment_group" ("shipment_id"),
  CONSTRAINT "FKrkgexcp0f6a1rksne3tfsujut" FOREIGN KEY ("shipment_id") REFERENCES "shipment" ("shipment_id")
)

--- CREATE TABLE `notification` ---
CREATE TABLE "notification" (
  "notifi_id" int NOT NULL AUTO_INCREMENT,
  "is_read" bit(1) NOT NULL,
  "message" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "shipment_id" int DEFAULT NULL,
  "time" datetime(6) NOT NULL,
  "user_id" int DEFAULT NULL,
  "group_order_id" int DEFAULT NULL,
  PRIMARY KEY ("notifi_id"),
  KEY "FKb0yvoep4h4k92ipon31wmdf7e" ("user_id"),
  CONSTRAINT "FKb0yvoep4h4k92ipon31wmdf7e" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `order_item` ---
CREATE TABLE "order_item" (
  "order_item_id" int NOT NULL AUTO_INCREMENT,
  "date_created" datetime(6) DEFAULT NULL,
  "date_deleted" datetime(6) DEFAULT NULL,
  "date_updated" datetime(6) DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "quantity" int NOT NULL,
  "total_price" double NOT NULL,
  "cart_id" int DEFAULT NULL,
  "order_id" int NOT NULL,
  "user_id" int NOT NULL,
  PRIMARY KEY ("order_item_id"),
  UNIQUE KEY "UK5gjhq2fmknk50h8859nf0bcmx" ("order_id"),
  KEY "FKkgu3wv2n7r2shg2wbvc4nsu7l" ("cart_id"),
  KEY "FKt5mosdtftirppcdhv4wk963m" ("user_id"),
  CONSTRAINT "FKkgu3wv2n7r2shg2wbvc4nsu7l" FOREIGN KEY ("cart_id") REFERENCES "cart" ("cart_id"),
  CONSTRAINT "FKt4dc2r9nbvbujrljv3e23iibt" FOREIGN KEY ("order_id") REFERENCES "orders" ("order_id"),
  CONSTRAINT "FKt5mosdtftirppcdhv4wk963m" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `orders` ---
CREATE TABLE "orders" (
  "order_id" int NOT NULL AUTO_INCREMENT,
  "address" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_updated" datetime DEFAULT NULL,
  "delivery_date" datetime DEFAULT NULL,
  "delivery_fee" double DEFAULT NULL,
  "discount_price" double NOT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "note" text COLLATE utf8mb4_general_ci,
  "order_date" datetime NOT NULL,
  "phone_number" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "status" enum('CANCELLED','CONFIRMED','WAITING') COLLATE utf8mb4_general_ci NOT NULL,
  "total_price" double NOT NULL,
  "user_id" int NOT NULL,
  "voucher_id" bigint DEFAULT NULL,
  "cancel_reason" enum('CHANGED_MY_MIND','DELIVERY_TOO_SLOW','FOUND_CHEAPER_ELSEWHERE','NOT_NEEDED_ANYMORE','ORDERED_BY_MISTAKE','OTHER_REASON','PAYMENT_ISSUES','PREFER_DIFFERENT_STORE','UNSATISFIED_WITH_SERVICE','WRONG_PRODUCT_SELECTED') COLLATE utf8mb4_general_ci DEFAULT NULL,
  "date_canceled" datetime DEFAULT NULL,
  "is_cancel_reason" bit(1) DEFAULT NULL,
  "point_coin_use" float DEFAULT NULL,
  PRIMARY KEY ("order_id"),
  KEY "FKel9kyl84ego2otj2accfd8mr7" ("user_id"),
  KEY "FKrx5vk9ur428660yp19hw98nr2" ("voucher_id"),
  CONSTRAINT "FKel9kyl84ego2otj2accfd8mr7" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id"),
  CONSTRAINT "FKrx5vk9ur428660yp19hw98nr2" FOREIGN KEY ("voucher_id") REFERENCES "voucher" ("voucher_id")
)

--- CREATE TABLE `otp` ---
CREATE TABLE "otp" (
  "otp_id" int NOT NULL AUTO_INCREMENT,
  "otp" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "status" bit(1) NOT NULL,
  "time_otp" datetime NOT NULL,
  "user_name" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "email" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY ("otp_id"),
  KEY "FK1fk48pp7wr309plc62bpw74jk" ("email"),
  CONSTRAINT "FK1fk48pp7wr309plc62bpw74jk" FOREIGN KEY ("email") REFERENCES "user" ("email")
)

--- CREATE TABLE `payments` ---
CREATE TABLE "payments" (
  "payment_id" int NOT NULL AUTO_INCREMENT,
  "amount" double NOT NULL,
  "date_created" datetime(6) DEFAULT NULL,
  "date_deleted" datetime(6) DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "order_id_payment" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "payment_method" enum('CASH','CREDIT') COLLATE utf8mb4_general_ci NOT NULL,
  "status" enum('COMPLETED','FAILED','PENDING','REFUND') COLLATE utf8mb4_general_ci NOT NULL,
  "order_id" int NOT NULL,
  "is_refunded" bit(1) DEFAULT NULL,
  "date_refunded" datetime DEFAULT NULL,
  "link" text COLLATE utf8mb4_general_ci,
  PRIMARY KEY ("payment_id"),
  UNIQUE KEY "UK8vo36cen604as7etdfwmyjsxt" ("order_id"),
  CONSTRAINT "FK81gagumt0r8y3rmudcgpbk42l" FOREIGN KEY ("order_id") REFERENCES "orders" ("order_id")
)

--- CREATE TABLE `payments_group` ---
CREATE TABLE "payments_group" (
  "payment_id" int NOT NULL AUTO_INCREMENT,
  "amount" double NOT NULL,
  "date_created" datetime(6) DEFAULT NULL,
  "date_deleted" datetime(6) DEFAULT NULL,
  "date_refunded" datetime DEFAULT NULL,
  "discount_percent" double DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "is_refunded" bit(1) DEFAULT NULL,
  "link" text COLLATE utf8mb4_general_ci,
  "order_id_payment" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "payment_method" enum('CASH','CREDIT') COLLATE utf8mb4_general_ci NOT NULL,
  "status" enum('COMPLETED','FAILED','PENDING','REFUND') COLLATE utf8mb4_general_ci NOT NULL,
  "group_order_id" int NOT NULL,
  PRIMARY KEY ("payment_id"),
  KEY "fk_group_order_id" ("group_order_id"),
  CONSTRAINT "fk_group_order_id" FOREIGN KEY ("group_order_id") REFERENCES "group_orders" ("group_order_id")
)

--- CREATE TABLE `post` ---
CREATE TABLE "post" (
  "post_id" bigint NOT NULL AUTO_INCREMENT,
  "banner_url" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "date_create" datetime(6) NOT NULL,
  "date_deleted" datetime(6) DEFAULT NULL,
  "description" text COLLATE utf8mb4_general_ci,
  "is_deleted" bit(1) DEFAULT NULL,
  "short_des" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "title" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "type" enum('DISCOUNT','EVENT','NEW') COLLATE utf8mb4_general_ci NOT NULL,
  "user_id" int NOT NULL,
  PRIMARY KEY ("post_id"),
  KEY "FK72mt33dhhs48hf9gcqrq4fxte" ("user_id"),
  CONSTRAINT "FK72mt33dhhs48hf9gcqrq4fxte" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `post_translation` ---
CREATE TABLE "post_translation" (
  "post_trans_id" bigint NOT NULL AUTO_INCREMENT,
  "date_create" datetime(6) NOT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "description" text COLLATE utf8mb4_general_ci,
  "is_deleted" bit(1) DEFAULT NULL,
  "language_code" enum('EN','VN') COLLATE utf8mb4_general_ci DEFAULT NULL,
  "short_des" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "title" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "post_id" bigint DEFAULT NULL,
  PRIMARY KEY ("post_trans_id"),
  KEY "FK918cv1v5x5vs2uuescygypo58" ("post_id"),
  CONSTRAINT "FK918cv1v5x5vs2uuescygypo58" FOREIGN KEY ("post_id") REFERENCES "post" ("post_id")
)

--- CREATE TABLE `price_history` ---
CREATE TABLE "price_history" (
  "history_id" int NOT NULL AUTO_INCREMENT,
  "change_reason" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "date_changed" datetime NOT NULL,
  "new_price" double NOT NULL,
  "old_price" double NOT NULL,
  "var_id" int NOT NULL,
  PRIMARY KEY ("history_id"),
  KEY "FK1djlj52eh9jgdvcavm5dqc4b" ("var_id"),
  CONSTRAINT "FK1djlj52eh9jgdvcavm5dqc4b" FOREIGN KEY ("var_id") REFERENCES "product_variants" ("var_id")
)

--- CREATE TABLE `product` ---
CREATE TABLE "product" (
  "pro_id" int NOT NULL AUTO_INCREMENT,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_updated" datetime DEFAULT NULL,
  "description" text COLLATE utf8mb4_general_ci NOT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "list_pro_img" text COLLATE utf8mb4_general_ci NOT NULL,
  "pro_name" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "category_id" int DEFAULT NULL,
  PRIMARY KEY ("pro_id"),
  KEY "FK1mtsbur82frn64de7balymq9s" ("category_id"),
  CONSTRAINT "FK1mtsbur82frn64de7balymq9s" FOREIGN KEY ("category_id") REFERENCES "category" ("cate_id")
)

--- CREATE TABLE `product_translation` ---
CREATE TABLE "product_translation" (
  "pro_trans_id" int NOT NULL AUTO_INCREMENT,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_updated" datetime DEFAULT NULL,
  "description" text COLLATE utf8mb4_general_ci NOT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "language_code" enum('EN','VN') COLLATE utf8mb4_general_ci DEFAULT NULL,
  "pro_name" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "pro_id" int DEFAULT NULL,
  PRIMARY KEY ("pro_trans_id"),
  KEY "FKi91apo1hg2g0dpms5fhxwj0kf" ("pro_id"),
  CONSTRAINT "FKi91apo1hg2g0dpms5fhxwj0kf" FOREIGN KEY ("pro_id") REFERENCES "product" ("pro_id")
)

--- CREATE TABLE `product_variants` ---
CREATE TABLE "product_variants" (
  "var_id" int NOT NULL AUTO_INCREMENT,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_updated" datetime DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "price" double NOT NULL,
  "size" enum('L','M','S') COLLATE utf8mb4_general_ci NOT NULL,
  "stock" int NOT NULL,
  "pro_id" int NOT NULL,
  PRIMARY KEY ("var_id"),
  UNIQUE KEY "UKlnqyv1m6iiohs1w461p2vkjsy" ("pro_id","size"),
  CONSTRAINT "FKjo9ykg9lsgirx0od3vt2jfpcb" FOREIGN KEY ("pro_id") REFERENCES "product" ("pro_id")
)

--- CREATE TABLE `review` ---
CREATE TABLE "review" (
  "review_id" int NOT NULL AUTO_INCREMENT,
  "content" text COLLATE utf8mb4_general_ci,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_updated" datetime DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "rating_star" int DEFAULT NULL,
  "pro_id" int NOT NULL,
  "user_id" int NOT NULL,
  PRIMARY KEY ("review_id"),
  KEY "FKpxif5c2yg8322fbotvs3aeiki" ("pro_id"),
  KEY "FKiyf57dy48lyiftdrf7y87rnxi" ("user_id"),
  CONSTRAINT "FKiyf57dy48lyiftdrf7y87rnxi" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id"),
  CONSTRAINT "FKpxif5c2yg8322fbotvs3aeiki" FOREIGN KEY ("pro_id") REFERENCES "product" ("pro_id")
)

--- CREATE TABLE `shipment` ---
CREATE TABLE "shipment" (
  "shipment_id" int NOT NULL AUTO_INCREMENT,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_delivered" datetime DEFAULT NULL,
  "date_shipped" datetime DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "status" enum('CANCELLED','SHIPPING','SUCCESS','WAITING') COLLATE utf8mb4_general_ci NOT NULL,
  "payment_id" int NOT NULL,
  "user_id" int DEFAULT NULL,
  "date_canceled" datetime DEFAULT NULL,
  "distance" double DEFAULT NULL,
  "note" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY ("shipment_id"),
  UNIQUE KEY "UKaa2ydyemd8m3wsp81qks4903e" ("payment_id"),
  KEY "FKsh7hhx6dbueu6ilnf92s9jub9" ("user_id"),
  CONSTRAINT "FK2g2rx292u6cuk4t4glphs1sro" FOREIGN KEY ("payment_id") REFERENCES "payments" ("payment_id"),
  CONSTRAINT "FKsh7hhx6dbueu6ilnf92s9jub9" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `shipment_group` ---
CREATE TABLE "shipment_group" (
  "shipment_id" int NOT NULL AUTO_INCREMENT,
  "date_canceled" datetime DEFAULT NULL,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_delivered" datetime DEFAULT NULL,
  "date_shipped" datetime DEFAULT NULL,
  "distance" double DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "note" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "status" enum('CANCELLED','SHIPPING','SUCCESS','WAITING') COLLATE utf8mb4_general_ci NOT NULL,
  "payment_id" int NOT NULL,
  "user_id" int DEFAULT NULL,
  PRIMARY KEY ("shipment_id"),
  UNIQUE KEY "UKi1cv59irp0fyp9bjwguuatje8" ("payment_id"),
  KEY "FK2ayjkl3cyuws0gh9bgmdfarh3" ("user_id"),
  CONSTRAINT "FK2ayjkl3cyuws0gh9bgmdfarh3" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id"),
  CONSTRAINT "FK3tvd7d0l5kw7lgpkgssadkgmr" FOREIGN KEY ("payment_id") REFERENCES "payments_group" ("payment_id")
)

--- CREATE TABLE `shipper_attendance` ---
CREATE TABLE "shipper_attendance" (
  "id" int NOT NULL AUTO_INCREMENT,
  "attendance_date" date NOT NULL,
  "check_in_time" datetime(6) DEFAULT NULL,
  "created_at" datetime(6) NOT NULL,
  "is_present" bit(1) NOT NULL,
  "note" text COLLATE utf8mb4_general_ci,
  "status" enum('ABSENT','LATE','NONE','ON_LEAVE','ON_TIME') COLLATE utf8mb4_general_ci NOT NULL,
  "updated_at" datetime(6) DEFAULT NULL,
  "user_id" int NOT NULL,
  PRIMARY KEY ("id"),
  KEY "FKrf9fsm0mlbs22027shonc9vb8" ("user_id"),
  CONSTRAINT "FKrf9fsm0mlbs22027shonc9vb8" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `shipper_commission_detail` ---
CREATE TABLE "shipper_commission_detail" (
  "id" int NOT NULL AUTO_INCREMENT,
  "bonus" double DEFAULT NULL,
  "commission_date" date NOT NULL,
  "daily_commission" decimal(12,2) NOT NULL,
  "note" text COLLATE utf8mb4_general_ci,
  "order_count" int NOT NULL,
  "user_id" int NOT NULL,
  PRIMARY KEY ("id"),
  KEY "FKomaoanegngrlnbcdda3bcjc4f" ("user_id"),
  CONSTRAINT "FKomaoanegngrlnbcdda3bcjc4f" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `shipper_salary_summary` ---
CREATE TABLE "shipper_salary_summary" (
  "id" int NOT NULL AUTO_INCREMENT,
  "approved_leave_days" int NOT NULL,
  "base_salary" decimal(12,2) NOT NULL,
  "commission" decimal(12,2) NOT NULL,
  "created_at" datetime(6) NOT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "month" int NOT NULL,
  "note" text COLLATE utf8mb4_general_ci,
  "total_orders" int NOT NULL,
  "total_salary" decimal(12,2) NOT NULL,
  "updated_at" datetime(6) DEFAULT NULL,
  "working_days" int NOT NULL,
  "year" int NOT NULL,
  "user_id" int NOT NULL,
  PRIMARY KEY ("id"),
  KEY "FKcb0of348deujp4irkpy2b32de" ("user_id"),
  CONSTRAINT "FKcb0of348deujp4irkpy2b32de" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `step_details` ---
CREATE TABLE "step_details" (
  "step_id" bigint NOT NULL AUTO_INCREMENT,
  "distance_text" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "duration_text" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "instruction" text COLLATE utf8mb4_general_ci,
  "latitude" double DEFAULT NULL,
  "longitude" double DEFAULT NULL,
  "map_direction_id" bigint DEFAULT NULL,
  PRIMARY KEY ("step_id"),
  KEY "FKgjv6l6fmp2ple3e9jpdltbohe" ("map_direction_id"),
  CONSTRAINT "FKgjv6l6fmp2ple3e9jpdltbohe" FOREIGN KEY ("map_direction_id") REFERENCES "map_directions" ("map_direction_id")
)

--- CREATE TABLE `token` ---
CREATE TABLE "token" (
  "token_id" bigint NOT NULL AUTO_INCREMENT,
  "access_token" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "expire" datetime(6) DEFAULT NULL,
  "refresh_token" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "user_id" int NOT NULL,
  PRIMARY KEY ("token_id"),
  UNIQUE KEY "UKg7im3j7f0g31yhl6qco2iboy5" ("user_id"),
  CONSTRAINT "FKe32ek7ixanakfqsdaokm4q9y2" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `user` ---
CREATE TABLE "user" (
  "user_id" int NOT NULL AUTO_INCREMENT,
  "avatar" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "birth_date" datetime(6) DEFAULT NULL,
  "city" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_updated" datetime DEFAULT NULL,
  "district" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "email" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "full_name" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "password" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "phone_number" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "role" enum('ADMIN','CUSTOMER','SHIPPER') COLLATE utf8mb4_general_ci NOT NULL,
  "sex" enum('FEMALE','MALE','OTHER') COLLATE utf8mb4_general_ci DEFAULT NULL,
  "street" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "type" enum('BASIC','BOTH','EMAIL') COLLATE utf8mb4_general_ci NOT NULL,
  "username" varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  "ward" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY ("user_id"),
  UNIQUE KEY "unique_email" ("email")
)

--- CREATE TABLE `user_chat` ---
CREATE TABLE "user_chat" (
  "user_chat_id" int NOT NULL AUTO_INCREMENT,
  "chat_name" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "date_created" datetime DEFAULT NULL,
  "date_deleted" datetime DEFAULT NULL,
  "date_updated" datetime DEFAULT NULL,
  "id_mongo_db" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "user_id" int DEFAULT NULL,
  PRIMARY KEY ("user_chat_id"),
  KEY "FKojd9hqbl3e7kq3vvr9ym218i4" ("user_id"),
  CONSTRAINT "FKojd9hqbl3e7kq3vvr9ym218i4" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `user_coin` ---
CREATE TABLE "user_coin" (
  "user_coin_id" int NOT NULL AUTO_INCREMENT,
  "point_coin" float DEFAULT NULL,
  "user_id" int DEFAULT NULL,
  PRIMARY KEY ("user_coin_id"),
  KEY "FKn9afcbhayp9k1vl22n3xsu8p5" ("user_id"),
  CONSTRAINT "FKn9afcbhayp9k1vl22n3xsu8p5" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `user_voucher` ---
CREATE TABLE "user_voucher" (
  "user_voucher_id" int NOT NULL AUTO_INCREMENT,
  "status" enum('INACTIVE','USED','EXPIRED') COLLATE utf8mb4_general_ci DEFAULT NULL,
  "user_id" int DEFAULT NULL,
  "voucher_id" bigint DEFAULT NULL,
  PRIMARY KEY ("user_voucher_id"),
  KEY "FK98wtp768dsh1cjpuiqbnphb7a" ("user_id"),
  KEY "FK5llb4x2ixiwa75csgei7hbl5r" ("voucher_id"),
  CONSTRAINT "FK5llb4x2ixiwa75csgei7hbl5r" FOREIGN KEY ("voucher_id") REFERENCES "voucher" ("voucher_id"),
  CONSTRAINT "FK98wtp768dsh1cjpuiqbnphb7a" FOREIGN KEY ("user_id") REFERENCES "user" ("user_id")
)

--- CREATE TABLE `voucher` ---
CREATE TABLE "voucher" (
  "voucher_id" bigint NOT NULL AUTO_INCREMENT,
  "date_deleted" datetime DEFAULT NULL,
  "discount" double NOT NULL,
  "end_date" datetime NOT NULL,
  "is_deleted" bit(1) DEFAULT NULL,
  "key_voucher" varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  "number" int NOT NULL,
  "start_date" datetime NOT NULL,
  "status" enum('ACTIVE','EXPIRED') COLLATE utf8mb4_general_ci NOT NULL,
  "post_id" bigint NOT NULL,
  PRIMARY KEY ("voucher_id"),
  UNIQUE KEY "UK9bucqlrk4o5cl79uaekv5620c" ("post_id"),
  CONSTRAINT "FKavteowywmy7sa540q5uvjf48l" FOREIGN KEY ("post_id") REFERENCES "post" ("post_id")
)
"""