prj3
Tables (31)
adopted_animal
- Key (adopted_animal_idx) — Primary key — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
- animal_idx — Bigint — Foreign key → animal.animal_idx — NOT NULL
- 입양 날짜 (adopted_date) — TimeStamp
animal
- animal_idx — Bigint — Primary key — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
- animal_name — VarChar
- age — int
- gender — char
- disease — VarChar
- breed — VarChar
- text_reason — LongText
- text_etc — LongText
- training — VarChar
- neutering — VarChar
- health_check — boolean
- created_at — TimeStamp
- nurture_period — VarChar
- kind — VarChar
animal_image
- image_idx — Bigint — Primary key — NOT NULL
- animal_idx — Bigint — Foreign key → animal.animal_idx — NOT NULL
- img — LongText
animal_scrap
- scrap_idx — Bigint — Primary key — NOT NULL
- animal_idx — Bigint — Foreign key → animal.animal_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
lost
- lost_board_idx — Bigint — Primary key — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
- category — VarChar
- place — VarChar
- reward — LongText
- mobile — VarChar
- kind — VarChar
- breed — VarChar
- gender — VarChar
- color — VarChar
- lost_date — Date
- lost_time — VarChar
- lost_minute — VarChar
- text — LongText
- created_at — TimeStamp
lost_board_like
- lost_board_like_idx — Bigint — Primary key — NOT NULL
- lost_board_idx — Bigint — Foreign key → lost.lost_board_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
lost_comments
- lost_comments_idx — Bigint — Primary key — NOT NULL
- lost_board_idx — Bigint — Foreign key → lost.lost_board_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
- comment — LongText
- created_at — TimeStamp
lost_comments_like
- lost_comments_like_idx — Bigint — Primary key — NOT NULL
- lost_comments_idx — Bigint — Foreign key → lost_comments.lost_comments_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
lost_image
- image_idx — Bigint — Primary key — NOT NULL
- lost_board_idx — Bigint — Foreign key → lost.lost_board_idx — NOT NULL
- url — LongText
mate
- mate_board_idx — Bigint — Primary key — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
- category — VarChar
- place — VarChar
- created_at — TimeStamp
- text — LongText
- like — Integer
mate_board_like
- mate_board_like_idx — Bigint — Primary key — NOT NULL
- mate_board_idx — Bigint — Foreign key → mate.mate_board_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
mate_comments
- mate_comments_idx — Bigint — Primary key — NOT NULL
- mate_board_idx — Bigint — Foreign key → mate.mate_board_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
- comment — LONGTEXT
- like — integer
- created_at — TimeStamp
mate_comments_like
- mate_comments_like_idx — Bigint — Primary key — NOT NULL
- mate_comments_idx — Bigint — Foreign key → mate_comments.mate_comments_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
mate_image
- mate_img_idx — Bigint — Primary key — NOT NULL
- mate_board_idx — Bigint — Foreign key → mate.mate_board_idx — NOT NULL
- img — LongText
mypage
- my_page_idx — Bigint — Primary key — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
- info — LongText
- img — LongText
mypet
- mypet_board_idx — Bigint — Primary key — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
- kind — VarChar
- text — LongText
- like — int
- breed — VarChar
- created_at — Timestamp
mypet_board_like
- mypet_board_like_idx — Bigint — Primary key — NOT NULL
- mypet_board_idx — Bigint — Foreign key → mypet.mypet_board_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
mypet_comments
- mypet_comments_idx — Bigint — Primary key — NOT NULL
- mypet_board_idx — Bigint — Foreign key → mypet.mypet_board_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
- comment — LONGTEXT
- like — Integer
- created_at — TimeStamp
mypet_comments_like
- mypet_comments_like_idx — Bigint — Primary key — NOT NULL
- mypet_comments_idx — Bigint — Foreign key → mypet_comments.mypet_comments_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
mypet_image
- image_idx — Bigint — Primary key — NOT NULL
- mypet_board_idx — Bigint — Foreign key → mypet.mypet_board_idx — NOT NULL
- url — LongText
review
- review_idx — Bigint — Primary key — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
- Key (adopted_animal_idx) — Foreign key → adopted_animal.Key — NOT NULL
- text_review — LongText
- like — int
- created_at — TimeStamp
review_comments_like
- review_comments_like_idx — Bigint — Primary key — NOT NULL
- review_contents_idx — Bigint — Foreign key → review_commnets.review_contents_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
review_commnets
- review_contents_idx — Bigint — Primary key — NOT NULL
- review_idx — Bigint — Foreign key → review.review_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
- comment — VarChar
- like — int
- created_at — TimeStamp
review_image
- image_idx — Bigint — Primary key — NOT NULL
- review_idx — Bigint — Foreign key → review.review_idx — NOT NULL
- url — LongText
review_like
- review_board_like_idx — Bigint — Primary key — NOT NULL
- review_idx — Bigint — Foreign key → review.review_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
tip_comments_like
- tip_comments_like_idx — Bigint — Primary key — NOT NULL
- tips_comments_idx — Bigint — Foreign key → tips_comments.tips_comments_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
tips
- tips_board_idx — Bigint — Primary key — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
- category — Varchar
- title — Varchar
- text — LongText
- like — int
- created_at — TimeStamp
tips_board_like
- tip_board_like_idx — Bigint — Primary key — NOT NULL
- tip_board_idx — Bigint — Foreign key → tips.tips_board_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
tips_comments
- tips_comments_idx — Bigint — Primary key — NOT NULL
- tip_board_idx — Bigint — Foreign key → tips.tips_board_idx — NOT NULL
- user_idx — Bigint — Foreign key → user.user_idx — NOT NULL
- comment — LongText
- like — int
- created_at — TimeStamp
tips_image
- image_idx — Bigint — Primary key — NOT NULL
- tips_board_idx — Bigint — Foreign key → tips.tips_board_idx — NOT NULL
- url — LongText
user
- user_idx — Bigint — Primary key — NOT NULL
- name — VarChar
- email — VarChar
- user_nickname — VarChar
- password — LongText
- gender — VarChar
- mobile — LongText
- city — VarChar
- town — VarChar
- experience — boolean