Matching Pet

Tables (10)

Admin (관리자)

  • admin_num (관리자번호) — Primary key — NOT NULL

Admin_list (관리자게시판)

  • ad_list_num (관리자게시판번호) — Primary key — NOT NULL
  • admin_num (관리자번호) — Foreign key → Admin.admin_num — NOT NULL

Adopt (입양)

  • adopt_num (입양번호) — Primary key — NOT NULL
  • user_num (유저 번호) — Foreign key → User.user_num — NOT NULL
  • adopt_list_num (입양목록번호) — Foreign key → Adopt_list.adopt_list_num — NOT NULL
  • animal_num (동물등록번호) — Foreign key → Animal.animal_num — NOT NULL

Adopt_list (입양신청이력)

  • adopt_list_num (입양목록번호) — Primary key — NOT NULL
  • user_num (유저 번호) — Foreign key → User.user_num — NOT NULL

Animal (동물)

  • animal_num (동물등록번호) — Primary key — NOT NULL
  • animal_type (동물종류) — NOT NULL
  • animal_name (동물이름) — NOT NULL
  • animal_gender (동물성별)
  • animal_age (동물나이)
  • animal_content (동물참조내용)
  • animal_disease (동물질병유무)
  • list_num (리스트번호) — Foreign key → List.list_num — NOT NULL
  • admin_num (관리자번호) — Foreign key → Admin.admin_num — NOT NULL

Comment (댓글)

  • comment_num (댓글번호) — Primary key — NOT NULL
  • user_num (유저 번호) — Foreign key → User.user_num — NOT NULL
  • animal_num (동물등록번호) — Foreign key → Animal.animal_num — NOT NULL

List (전체리스트)

  • list_num (리스트번호) — Primary key — NOT NULL

Rec_list (추천리스트)

  • rec_list_num (추천리스트번호) — Primary key — NOT NULL
  • animal_num (동물등록번호) — Foreign key → Animal.animal_num — NOT NULL

User (사용자)

  • user_num (유저 번호) — Primary key — NOT NULL
  • user_id (아이디) — NOT NULL
  • user_pw (비밀번호) — NOT NULL
  • user_phone (전화번호)
  • user_age (나이) — NOT NULL
  • user_name (이름) — NOT NULL
  • rec_list_num (추천리스트번호) — Foreign key → Rec_list.rec_list_num — NOT NULL

User_list (유저게시판)

  • user_list_num (유저게시판번호) — Primary key — NOT NULL
  • user_num (유저 번호) — Foreign key → User.user_num — NOT NULL