ㅁㄴㅇㅁㄴㅇ
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