반려동물 비대면 상담 서비스
테이블 (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