Model Diagram

Untitled

Models / Database

๐Ÿ‘ค User table ( ์‚ฌ์šฉ์ž ํ…Œ์ด๋ธ” )

name property description
id int, pk ์œ ์ € ๊ณ ์œ  id๊ฐ’
user_id string ์œ ์ € ์„ค์ • ID
password string ์œ ์ € ๋น„๋ฐ€๋ฒˆํ˜ธ
phone string ์œ ์ € ์ „ํ™”๋ฒˆํ˜ธ
image file ์œ ์ € ํ”„๋กœํ•„ ์‚ฌ์ง„
user_created date ๊ฐ€์ž… ๋‚ ์งœ
user_updated date ์œ ์ € ์ •๋ณด ์ˆ˜์ • ๋‚ ์งœ (๋กœ๊ทธ๊ธฐ๋ก)
recruitment_id foreignkey ๊ตฌ์ธ ๋‚ด์—ญ (๊ตฌ์ธ๋“ฑ๋ก tbl๊ณผ 1:M์—ฐ๊ฒฐ)
application_id foreignkey ๊ตฌ์ง ์‹ ์ฒญ ๊ธฐ๋ก (์‹ ์ฒญ tbl๊ณผ 1:M ์—ฐ๊ฒฐ)
inquiry_id foreignkey ๋ฌธ์˜ ๋‚ด์—ญ (๋ฌธ์˜ tbl๊ณผ 1:M ์—ฐ๊ฒฐ)
bookmark_id foreignkey ๋ถ๋งˆํฌ ๋‚ด์—ญ (์ƒํ’ˆ tbl๊ณผ ์—ฐ๊ฒฐ)

๐Ÿ“„ Recruitment table ( ๊ตฌ์ธ๊ธ€ ํ…Œ์ด๋ธ” )

name property description
post-id pk ๊ตฌ์ง ๊ธ€ ๊ณ ์œ  id๊ฐ’
user-id foreignkey user tbl๊ณผ 1:1 ์—ฐ๊ฒฐ
work_name string ์ž‘์—… ๋‚ด์šฉ (์ œ๋ชฉ)
image file ์ด๋ฏธ์ง€ ํŒŒ์ผ
address string ์ฃผ์†Œ (์ฃผ์†Œapi ์—ฐ๊ฒฐ)
detailed_address string ์ƒ์„ธ ์ฃผ์†Œ (์ง์ ‘ ์ž‘์„ฑ)
district choice (enum) ์ง€์—ญ๊ตฌ
start_date date ์ž‘์—… ์‹œ์ž‘ ์ผ์ž
end_date date ์ž‘์—… ์ข…๋ฃŒ ์ผ์ž
start_time time ์ž‘์—… ์‹œ์ž‘ ์‹œ๊ฐ„
end_time time ์ž‘์—… ์ข…๋ฃŒ ์‹œ๊ฐ„
days_of_work int ์ผํ•˜๋Š” ๊ธฐ๊ฐ„
num_of_people int ํ•„์š” ์ธ์› (๊ณ ์šฉ ์ธ์›)
daily_wage int ์ผ๋‹น Pay (๋‹จ์œ„: ์›)
lodging_offered boolean ์ˆ™์†Œ ์ œ๊ณต ์—ฌ๋ถ€
recommended_lodging string loding_offered ๊ฐ€ false ์ธ ๊ฒฝ์šฐ ์ธ๊ทผ ์ˆ™๋ฐ•์‹œ์„ค ์ถ”์ฒœ
meal_offered boolean ์‹์‚ฌ ์ œ๊ณต ์—ฌ๋ถ€
trans_offered boolean ๊ตํ†ต ์ง€์› ์—ฌ๋ถ€
contents string ์ƒ์„ธ ์„ค๋ช…
tags multiple ํƒœ๊ทธ ๋ชฉ๋ก
is_closed boolean ๊ตฌ์ธ์ด ๋งˆ๊ฐ ๋˜์—ˆ๋Š”์ง€? (default: false )

โœ‹๐Ÿป Application Table

name property description
application-id pk ๊ตฌ์ง ๊ณ ์œ id๊ฐ’
user-id foreignkey user tbl๊ณผ 1:1 ์—ฐ๊ฒฐ
post-id foreignkey recruitment-tbl๊ณผ 1:M ์—ฐ๊ฒฐ
application_date date ์‹ ์ฒญ ๋‚ ์งœ
is_paid boolean ๊ฒฐ์ œ ์™„๋ฃŒ ํ–ˆ๋Š”์ง€ ์•ˆํ–ˆ๋Š”์ง€ (default : false )
is_cancled boolean ์‹ ์ฒญ ์ทจ์†Œ (default: false , ํ•œ๋ฒˆ true ๋กœ ์„ค์ •๋˜๋ฉด ๊ฒฐ์ œ tbl๋„ ์ทจ์†Œ)

API endpoints

๐Ÿ‘ค User Authentication API

name http method url pattern description Body (json) Response
ํšŒ์›๊ฐ€์ž… POST / oseyou / signup ์ƒˆ๋กœ์šด ์œ ์ € ๋“ฑ๋ก id, image, name, password, password_validated, phone, user_id
๋กœ๊ทธ์ธ POST / oseyou / login ๋กœ๊ทธ์ธ password, user_id
๋กœ๊ทธ์•„์›ƒ POST / oseyou / logout ๋กœ๊ทธ์•„์›ƒ

๐Ÿ“Ž User Management API