Petwork
Tables (15)
board
- board_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- board_type — INT — NOT NULL — 게시물 종류(산책 거래 고용)
- title — VARCHAR(45) — NOT NULL
- content — VARCHAR(45) — NOT NULL
- report_count — INT — NOT NULL — 신고수
- click_count — INT — NOT NULL — 조회수
- local_si — INT — NOT NULL
- local_gu — INT — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
- update — TIMESTAMP — NOT NULL
board_hire
- board_hire_id — INT — Primary key — NOT NULL
- hire_condition — VARCHAR(100) — NOT NULL
- hire_date — DATETIME — NOT NULL
- hire_price — INT — NOT NULL
- hire_category — INT — NOT NULL
- board_id — INT — Foreign key → board.board_id — NOT NULL
board_petstar_comment
- board_petstar_comment_id — INT — Primary key — NOT NULL
- comment_user — VARCHAR(45) — NOT NULL
- comment_content — VARCHAR(45) — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
- board_id — INT — Foreign key → board.board_id — NOT NULL
board_photo
- board_photo_id — INT — Primary key — NOT NULL
- board_id — INT — Foreign key → board.board_id — NOT NULL
- board_photo_name — VARCHAR(255) — NOT NULL
- board_photo_src — VARCHAR(255) — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
board_trade
- board_trade_id — INT — Primary key — NOT NULL
- trade_price — INT — NOT NULL
- trade_category — INT — NOT NULL
- board_id — INT — Foreign key → board.board_id — NOT NULL
board_walk
- board_walk_id — INT — Primary key — NOT NULL
- walk_category — INT — NOT NULL
- board_id — INT — Foreign key → board.board_id — NOT NULL
chat
- chat_id — INT — Primary key — NOT NULL
- chatroom_id — INT — Foreign key → chatroom.chatroom_id — NOT NULL
- sender — VARCHAR(45) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- message_type — INT — NOT NULL — 1.enter 2.exit 3.talk
- reg_date — TIMESTAMP — NOT NULL
chatroom
- chatroom_id — INT — Primary key — NOT NULL
- board_id — INT — Foreign key → board.board_id — NOT NULL
- chatroom_name — VARCHAR(45) — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
chatroom_user
- chatroom_user_id — INT — Primary key — NOT NULL
- chatroom_id — INT — Foreign key → chatroom.chatroom_id — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- user_name — VARCHAR(45) — NOT NULL
map
- map_id — INT — Primary key — NOT NULL
- latitude — VARCHAR(45) — NOT NULL
- longitude — VARCHAR(45) — NOT NULL
- board_id — INT — Foreign key → board.board_id — NOT NULL
notification
- notification_id — INT — Primary key — NOT NULL
- chatroom_id — INT — Foreign key → chatroom.chatroom_id — NOT NULL
- content — VARCHAR(255) — NOT NULL
- is_read — TINYINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
pet
- pet_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- pet_name — VARCHAR(45) — NOT NULL
- pet_type — VARCHAR(45) — NOT NULL — 애완동물 종류
- pet_category — INT — NOT NULL — 애완동물 크기(대 중 소)
- pet_introduce — VARCHAR(255) — 애완동물 소개
pet_photo
- pet_photo_id — INT — Primary key — NOT NULL
- pet_id — INT — Foreign key → pet.pet_id — NOT NULL
- pet_photo_name — VARCHAR(255) — NOT NULL
- pet_photo_src — VARCHAR(255) — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
report
- report_id — INT — Primary key — NOT NULL
- board_id — INT — Foreign key → board.board_id — NOT NULL
- sender_id — INT — Foreign key → user.user_id — NOT NULL
- report_type — INT — NOT NULL — 신고 사유
- report_comment — VARCHAR(255) — NOT NULL — 자세한 신고 내용
- reg_date — TIMESTAMP — NOT NULL
user
- user_id — INT — Primary key — NOT NULL
- name — VARCHAR(45) — NOT NULL — 이름
- nickname — VARCHAR(45) — NOT NULL — 닉네임
- password — VARCHAR(255) — NOT NULL — 비밀번호
- tel_number — VARCHAR(45) — NOT NULL
- email — VARCHAR(45) — NOT NULL
- local_si — INT — NOT NULL
- local_gu — INT — NOT NULL
- preference — INT — NOT NULL — 선호도
- reg_date — TIMESTAMP — NOT NULL
- update — TIMESTAMP — NOT NULL
- is_admin — TINYINT — NOT NULL — 0 false / 1 true / 관리자 식별자