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