반려동물 비대면 상담 서비스

테이블 (13)

calender_memo

  • calender_memo_id — int — 기본 키 — NOT NULL
  • pet_id — int — 외래 키 → pet.pet_id — NOT NULL
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • calender_category — varchar(100) — NOT NULL
  • calender_title — varchar(100)
  • calender_content — varchar(200) — NOT NULL
  • calender_date — DateTime — NOT NULL

chat_room

  • chat_room_id — int — 기본 키 — NOT NULL
  • host_id — int — 외래 키 → user.user_id — NOT NULL
  • chat_room_title — varchar(50) — NOT NULL
  • start_time — DateTime — NOT NULL
  • user_max_count — int — NOT NULL
  • user_now_count — int

chat_room_history

  • chat_room_history_id — int — 기본 키 — NOT NULL
  • host_id — int — NOT NULL
  • chat_room_title — varchar(50) — NOT NULL
  • start_time — DateTime — NOT NULL
  • end_time — DateTime — NOT NULL
  • user_max_count — int — NOT NULL

chat_room_tag

  • chat_room_tag_id (chat_room_tag) — int — 기본 키 — NOT NULL
  • chat_room_id — int — 외래 키 → chat_room.chat_room_id — NOT NULL
  • chat_room_tag_name — varchar(50) — NOT NULL

expenditure

  • expenditure_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • expenditure_category — varchar(100) — NOT NULL
  • expenditure_item — varchar(50) — NOT NULL
  • expenditure_price — int — NOT NULL
  • expenditure_date — DateTime

file

  • file_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • file_url — varchar(200)

pet

  • pet_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • pet_photo — varchar(200)
  • pet_name — varchar(20)
  • pet_kind — varchar(20)
  • pet_breed — varchar(20)
  • pet_birthday — DateTime
  • pet_gender — varchar(5)
  • pet_neutering — boolean
  • pet_vaccination — boolean

user

  • user_id — int — 기본 키 — NOT NULL
  • user_email — varchar(100) — NOT NULL
  • user_password — varchar(20) — NOT NULL
  • user_photo — varchar(200)
  • user_nickname — varchar(20) — NOT NULL
  • user_phone — int
  • user_kind — int
  • user_grade — int
  • user_active — boolean
  • user_regdate — DateTime

user_chat_room

  • user_chat_room_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • chat_room_id — int — 외래 키 → chat_room.chat_room_id — NOT NULL

user_tag

  • user_tag_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • user_tag_name — varchar(50) — NOT NULL

user_video_chat_room

  • video_chat_room_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • video_chat_room — int — 외래 키 → video_chat_room.video_chat_room — NOT NULL

video_chat_room

  • video_chat_room — int — 기본 키 — NOT NULL
  • host_id — int — 외래 키 → user.user_id — NOT NULL
  • chat_room_title — varchar(50) — NOT NULL
  • start_time — DateTime — NOT NULL
  • user_max_count — int — NOT NULL

video_chat_room_history

  • video_chat_room_history_id — int — 기본 키 — NOT NULL
  • host_id — int — NOT NULL
  • chat_room_title — varchar(50) — NOT NULL
  • start_time — DateTime — NOT NULL
  • end_time — DateTime — NOT NULL
  • user_max_count — int — NOT NULL