PJT1

Tables (15)

board

  • board_id — unsigned int — Primary key
  • user_id — unsigned int — Foreign key → user.user_id — NOT NULL
  • dog_id — unsigned int — Foreign key → dog.dog_id — NOT NULL
  • image — char(36) — NOT NULL
  • content — varchar(280)

chatroom

  • chatroom_id — unsigned int — Primary key — NOT NULL

chatting

  • chatting_id — unsigned int — Primary key — NOT NULL
  • chatting_user_id — unsigned int — Foreign key → user.user_id
  • chatting_room_id — unsigned int — Foreign key → chatroom.chatroom_id — NOT NULL
  • chatting_content — varchar(100)
  • chatting_date — date
  • chatting_idx — unsigned int

chatuser

  • chatuser_id — unsigned int — Primary key — NOT NULL
  • chatuser_other_id — unsigned int — Foreign key → user.user_id
  • chatuser_user_id — unsigned int — Foreign key → user.user_id
  • chat_room_id — unsigned int — Foreign key → chatroom.chatroom_id — NOT NULL
  • activation — int
  • start_chat_num — unsigned int
  • last_chat_num — unsigned int
  • lasttest_chat — unsigned int

comment

  • comment_id — unsigned int — Primary key
  • user_id — unsigned int — Foreign key → user.user_id — NOT NULL
  • board_id — unsigned int — Foreign key → board.board_id
  • comment_content — varchar(100) — NOT NULL

dog

  • dog_id — unsigned int — Primary key
  • user_id — unsigned int — Foreign key → user.user_id
  • dog_name — varchar(10) — NOT NULL
  • dog_gender — char(1) — NOT NULL
  • dog_type — varchar(50) — NOT NULL
  • dog_birth — char(6) — NOT NULL
  • dog_weight — varchar(4) — NOT NULL
  • dog_neutered — boolean — NOT NULL
  • dog_character1 — char(1) — NOT NULL — i : independent d : dependent
  • dog_character2 — char(1) — NOT NULL — a : active i : inactive
  • dog_image — varchar(100)
  • description — varchar(40) — NOT NULL

facility

  • facility_id — unsigned int — Primary key — NOT NULL
  • facility_name — varchar(100)
  • facility_address — varchar(100)
  • type — varchar(12)
  • longitude — varchar(11)
  • latitude — varchar(11)
  • closed_days — varchar(100)
  • opening_hours — varchar(100)
  • phone — char(13)

follow

  • follow_id — unsigned int — Primary key
  • follow_user_id — int(unsigned) — Foreign key → user.user_id — NOT NULL
  • followed_dog_id — int(unsigned) — Foreign key → dog.dog_id — NOT NULL

like

  • like_id — unsigned int — Primary key
  • user_id — unsigned int — Foreign key → user.user_id — NOT NULL
  • board_id — unsigned int — Foreign key → board.board_id

notify

  • notify_id — unsigned int — Primary key
  • receiver_user_id — unsigned int — Foreign key → user.user_id
  • sender_user_id — unsigned int — Foreign key → user.user_id
  • notify_type (type) — char(1) — NOT NULL — follow : 'f' like : 'l' cancel : 'c'
  • dog_id — unsigned int
  • board_id — unsigned int — type : f -> sender : userid type: l -> sender : feedid
  • notify_date — date — NOT NULL — notify date for sorting
  • check — boolean — whether one checked

received_request_dog

  • received_id — unsigned int — Primary key — NOT NULL
  • room_id — unsigned int — Foreign key → request.room_id — NOT NULL
  • dog_id — unsigned int — Foreign key → dog.dog_id

request

  • room_id — unsigned int — Primary key — NOT NULL
  • sent_user_id — unsigned int — Foreign key → user.user_id
  • received_user_id — unsigned int — Foreign key → user.user_id
  • place — varchar(40)
  • date_time — date
  • status — char(1) — NOT NULL — a: accepted n : not confirmed c : canceled
  • is_sender_rate — boolean
  • is_receiver_rate — boolean — false

sent_request_dog

  • sent_id — unsigned int — Primary key — NOT NULL
  • room_id — unsigned int — Foreign key → request.room_id — NOT NULL
  • dog_id — unsigned int — Foreign key → dog.dog_id

user

  • user_id — unsigned int — Primary key
  • email — varchar(50) — NOT NULL
  • nickname — varchar(16)
  • password — char(64) — NOT NULL
  • user_birth — char(4)
  • user_gender — char(1) — NOT NULL
  • address — varchar(100)
  • region_code — char(5)
  • social — char(1) — naver : 'n' kakao : 'k' google : 'g' origin : 'o'
  • rating_sum — unsigned int
  • rating_count — unsigned int
  • role_type — varchar(5)

wait_user

  • user_id — unsigned int — Primary key
  • email — varchar(50) — NOT NULL
  • nickname — varchar(16)
  • password — char(64) — NOT NULL
  • user_birth — char(4)
  • user_gender — char(1) — NOT NULL
  • address — varchar(100)
  • region_code — char(5)
  • regist_date — date — NOT NULL