[ShareMore] 0. ERD ์ž‘์„ฑ

1

[ํ† ์ดํ”„๋กœ์ ํŠธ] Share More

๋ชฉ๋ก ๋ณด๊ธฐ
1/6
post-thumbnail

๐Ÿ“„ ํ”„๋กœ์ ํŠธ์˜ ERD๋ฅผ ์„ค๊ณ„ํ•ฉ๋‹ˆ๋‹ค!

  1. User(์‚ฌ์šฉ์ž): ์‚ฌ์šฉ์ž์— ๋Œ€ํ•œ ์ •๋ณด๋ฅผ ์ €์žฅํ•ฉ๋‹ˆ๋‹ค.
    • ID: ์‚ฌ์šฉ์ž์˜ ๊ณ ์œ ๋ฒˆํ˜ธ
    • Name: ์‚ฌ์šฉ์ž ์ด๋ฆ„
    • Email: ์‚ฌ์šฉ์ž ์ด๋ฉ”์ผ
    • Password: ์‚ฌ์šฉ์ž ๋น„๋ฐ€๋ฒˆํ˜ธ
    • Address: ์‚ฌ์šฉ์ž ์ฃผ์†Œ

  2. Item(๋ฌผ๊ฑด): ๊ณต์œ ๋˜๋Š” ๋ฌผ๊ฑด์— ๋Œ€ํ•œ ์ •๋ณด๋ฅผ ์ €์žฅํ•ฉ๋‹ˆ๋‹ค.
    • ID: ๋ฌผ๊ฑด์˜ ๊ณ ์œ ๋ฒˆํ˜ธ
    • Name: ๋ฌผ๊ฑด ์ด๋ฆ„
    • Description: ๋ฌผ๊ฑด ์„ค๋ช…
    • Category: ๋ฌผ๊ฑด ์นดํ…Œ๊ณ ๋ฆฌ
    • Price: ๋ฌผ๊ฑด ๊ฐ€๊ฒฉ
    • Owner_ID: ๋ฌผ๊ฑด ์†Œ์œ ์ž์˜ ๊ณ ์œ ๋ฒˆํ˜ธ (User ํ…Œ์ด๋ธ”์˜ ID์™€ ์—ฐ๊ฒฐ)
    • item_image: ๋ฌผ๊ฑด ์†Œ์œ ์ž์˜ ๊ณ ์œ ๋ฒˆํ˜ธ (User ํ…Œ์ด๋ธ”์˜ ID์™€ ์—ฐ๊ฒฐ)

  3. Reservation(์˜ˆ์•ฝ): ๋ฌผ๊ฑด ์˜ˆ์•ฝ์— ๋Œ€ํ•œ ์ •๋ณด๋ฅผ ์ €์žฅํ•ฉ๋‹ˆ๋‹ค.
    • ID: ์˜ˆ์•ฝ์˜ ๊ณ ์œ ๋ฒˆํ˜ธ
    • User_ID: ์˜ˆ์•ฝํ•œ ์‚ฌ์šฉ์ž์˜ ๊ณ ์œ ๋ฒˆํ˜ธ (User ํ…Œ์ด๋ธ”์˜ ID์™€ ์—ฐ๊ฒฐ)
    • Item_ID: ์˜ˆ์•ฝ๋œ ๋ฌผ๊ฑด์˜ ๊ณ ์œ ๋ฒˆํ˜ธ (Item ํ…Œ์ด๋ธ”์˜ ID์™€ ์—ฐ๊ฒฐ)
    • Start_Date: ์˜ˆ์•ฝ ์‹œ์ž‘ ๋‚ ์งœ
    • End_Date: ์˜ˆ์•ฝ ์ข…๋ฃŒ ๋‚ ์งœ

  4. Review(ํ›„๊ธฐ): ๋ฌผ๊ฑด ์‚ฌ์šฉ ํ›„๊ธฐ์— ๋Œ€ํ•œ ์ •๋ณด๋ฅผ ์ €์žฅํ•ฉ๋‹ˆ๋‹ค.
    • ID: ํ›„๊ธฐ์˜ ๊ณ ์œ ๋ฒˆํ˜ธ
    • reviewer_ID: ํ›„๊ธฐ๋ฅผ ๋‚จ๊ธด ์‚ฌ์šฉ์ž์˜ ๊ณ ์œ ๋ฒˆํ˜ธ (User ํ…Œ์ด๋ธ”์˜ ID์™€ ์—ฐ๊ฒฐ)
    • reviewee_ID: ํ›„๊ธฐ๋ฅผ ๋‚จ๊ธด ์‚ฌ์šฉ์ž์˜ ๊ณ ์œ ๋ฒˆํ˜ธ (User ํ…Œ์ด๋ธ”์˜ ID์™€ ์—ฐ๊ฒฐ)
    • Rating: ํ‰์ 
    • Comment: ์ฝ”๋ฉ˜ํŠธ

profile
์ฝ”๋”ฉ์€์žฌ๋ฐŒ์–ด

0๊ฐœ์˜ ๋Œ“๊ธ€