SQL

CREATE TABLE `user_consumer_info` (
int형 id
`user_id` varchar(45) NOT NULL,
`password` varchar(100) DEFAULT NULL,
`name` varchar(45) DEFAULT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `user_merchant_info` (
int형 id
`user_id` varchar(45) NOT NULL,
`password` varchar(100) DEFAULT NULL,
`name` varchar(45) DEFAULT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `user_rider_info` (
int형 id (auto)
`user_id` varchar(45) NOT NULL,
`password` varchar(100) DEFAULT NULL,
`name` varchar(45) DEFAULT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `shop_essential_info` (

`shop_id` int NOT NULL, `category` varchar(45) DEFAULT NULL, `brand` varchar(45) DEFAULT NULL, `location` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, PRIMARY KEY (`shop_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `shop_status_info` (
`shop_id` int NOT NULL,
`open_time` time DEFAULT NULL,
`close_time` time DEFAULT NULL,
`shop_open_status` varchar(45) DEFAULT ‘CLOSE’,
`closing_day` varchar(45) DEFAULT ‘NO’,
PRIMARY KEY (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `shop_convenience_info` (
`shop_id` int NOT NULL,
`grade` varchar(45) DEFAULT NULL,
`delivery_method` varchar(45) DEFAULT NULL,
`shop_payment_method` varchar(45) DEFAULT NULL,
PRIMARY KEY (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;