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