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)