project2 backup1
Tables (19)
hotel_address
- address_pk — int — Primary key — NOT NULL
- buildingCode — varchar
- jibunaddress — varchar
- roadaddress — varchar
- sido — varchar
- sigungu — varchar
hotel_category
- hotel_categoty_pk (hotel_category_pk) — int — Primary key — NOT NULL
- hotel_category_nm — varchar
hotel_fav
- hotel_pk — int — Foreign key → t_hotel.hotel_pk — NOT NULL
- user_pk — int — Foreign key → t_user.user_pk — NOT NULL
review_pic
- review_pic_pk — int — Primary key — NOT NULL
- pic — varchar
- created_at — datetime
- review_pk — int — Foreign key → t_review.review_pk — NOT NULL
t_acceptable_size
- hotel_pk — int — Foreign key → t_hotel.hotel_pk — NOT NULL
- size_pk — int — Foreign key → t_dog_size.size_pk — NOT NULL
- maximum — int
t_dog_info
- dog_pk — int — Primary key — NOT NULL
- user_pk — int — Foreign key → t_user.user_pk — NOT NULL
- size_pk — int — Foreign key → t_dog_size.size_pk — NOT NULL
- dog_nm — VARCHAR
- dog_pic — varchar
- dog_info — varchar
t_dog_size
- size_pk — int — Primary key — NOT NULL
- dog_size — int
t_gallery
- gallery_pk — int — Primary key — NOT NULL
- gallery_category_pk — tinyint — Foreign key → t_gallery_category.gallery_category_pk — NOT NULL
- user_pk — int — Foreign key → t_user.user_pk — NOT NULL
- title — varchar(100)
- contents — varchar(5000)
- created_at — date
- updated_at — date
t_gallery_category
- gallery_category_pk — tinyint — Primary key — NOT NULL
- category_nm — varchar(10)
t_gallery_comment
- comment_pk — int — Primary key — NOT NULL
- user_pk — int — Foreign key → t_user.user_pk — NOT NULL
- gallery_pk — int — Foreign key → t_gallery.gallery_pk — NOT NULL
- comment — varchar(200)
- created_at — date
- updared_at — date
t_gallery_fav
- feed_fav_pk — int — Primary key — NOT NULL
- gallery_pk — int — Foreign key → t_gallery.gallery_pk — NOT NULL
- user_pk — int — Foreign key → t_user.user_pk — NOT NULL
- created_at — date
t_gallery_pics
- gallery_pic_pk — int — Primary key — NOT NULL
- pic — varchar(2100)
- created_at — date
- gallery_pk — int — Foreign key → t_gallery.gallery_pk — NOT NULL
t_hotel
- hotel_pk — int — Primary key — NOT NULL
- user_pk — int — Foreign key → t_user.user_pk — NOT NULL
- address_pk — int — Foreign key → hotel_address.address_pk — NOT NULL
- hotel_categoty_pk (hotel_category_pk) — int — Foreign key → hotel_category.hotel_categoty_pk — NOT NULL
- hotel_nm — varchar(100)
- contents — varchar(3000)
- created_at — date
- updated_at — date
- business_num — varchar
- hotel_callnum — varchar(15)
t_hotel_pic
- hotel_pic_pk — int — Primary key — NOT NULL
- hotel_pk (hotel_pk2) — int — Foreign key → t_hotel.hotel_pk — NOT NULL
- pic — varchar(2100)
- created_at — date
t_reservation
- res_pk — int — Primary key — NOT NULL
- hotel_pk — int — Foreign key → t_hotel.hotel_pk — NOT NULL
- user_pk — int — Foreign key → t_user.user_pk — NOT NULL
- from_date — date
- to_date — date
- created_at — date
- updated_at — date
t_reservation_dog_info
- res_dog_pk — int — Primary key — NOT NULL
- res_pk — int — Foreign key → t_reservation.res_pk — NOT NULL
- size_pk — int — Foreign key → t_dog_size.size_pk — NOT NULL
- dog_count — int
t_review
- review_pk — int — Primary key — NOT NULL
- res_pk — int — Foreign key → t_reservation.res_pk — NOT NULL
- comment — varchar
- score — int
- created_at — datetime
t_user
- user_pk — int — Primary key — NOT NULL
- user_type_pk — tinyint — Foreign key → t_user_type.user_type_pk — NOT NULL
- uid — varchar(30)
- upw — varchar(30)
- nm — varchar(10)
- pic — varchar(2100)
- email — varchar(100)
- phone_num — varchar
- created_at — date
- updated_at — date
t_user_type
- user_type_pk — tinyint — Primary key — NOT NULL
- user_type — varchar(10)