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 / 관리자 식별자