ㅁㄴㅇㅁㄴㅇ

Tables (14)

hotel_fav

  • user_pk — int — Foreign key → t_user.user_pk — NOT NULL
  • hotel_pk — int — Foreign key → t_hotel.hotel_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_buisness_user

  • buisness_pk — int — Primary key — NOT NULL
  • buisness_id — varchar
  • buisness_pw — varchar
  • buisness_nm — varchar
  • buisness_email — varchar
  • created_at — datetime

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 — varchar

t_feed

  • gallery_pk — int — Primary key — NOT NULL
  • user_pk — int — Foreign key → t_user.user_pk — NOT NULL
  • gallery_category_pk — int — Foreign key → t_feed_category.gallery_category_pk — NOT NULL
  • title — varchar(100)
  • contents — varchar(5000)
  • created_at — date
  • updated_at — date

t_feed_category

  • gallery_category_pk — tinyint — Primary key — NOT NULL
  • category_nm — varchar(10)

t_feed_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_feed.gallery_pk — NOT NULL
  • comment — varchar(200)
  • created_at — date
  • updared_at — date

t_feed_fav

  • user_pk — int — Foreign key → t_user.user_pk — NOT NULL
  • gallery_pk — int — Foreign key → t_feed.gallery_pk — NOT NULL
  • created_at — date

t_feed_pics

  • gallery_pic_pk — int — Primary key — NOT NULL
  • gallery_pk — int — Foreign key → t_feed.gallery_pk — NOT NULL
  • pic — varchar(2100)
  • created_at — date

t_hotel

  • hotel_pk — int — Primary key — NOT NULL
  • buisness_pk — int — Foreign key → t_buisness_user.buisness_pk — NOT NULL
  • title — varchar(100)
  • contents — varchar(3000)
  • created_at — date
  • updated_at — date

t_hotel_pic

  • hotel_pic_pk — int — Primary key — NOT NULL
  • hotel_pk — int — Foreign key → t_hotel.hotel_pk — NOT NULL
  • pic — varchar(2100)
  • created_at — date

t_reservation

  • res_pk — int — Primary key — NOT NULL
  • user_pk2 — int — Foreign key → t_user.user_pk — NOT NULL
  • hotel_pk — int — Foreign key → t_hotel.hotel_pk — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)

t_user

  • user_pk — int — Primary key — NOT NULL
  • uid — varchar(30)
  • upw — varchar(30)
  • nm — varchar(10)
  • pic — varchar(2100)
  • email — varchar(100)
  • created_at — date
  • updated_at — date