Skip to content

yaaasuu/booking

Repository files navigation

booking

起動方法

npm install
npm run dev

DBはmysqlを使用しており、部屋の一覧(rooms)、予約管理(books)の二つに分かれています

CREATE TABLE rooms (room INT NOT NULL , max INT NOT NULL , bed_size varchar(255) NOT NULL , PRIMARY KEY (room));

CREATE TABLE books (room INT NOT NULL ,book_id INT AUTO_INCREMENT NOT NULL, first_name varchar(255) NOT NULL , last_name varchar(255) NOT NULL , phone_number varchar(255) NOT NULL, passport_number varchar(255) , remarks varchar(255) , guests INT NOT NULL ,arrival DATE NOT NULL, departure DATE NOT NULL, PRIMARY KEY (book_id), FOREIGN KEY (room) REFERENCES rooms(room));

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages