Skip to content

LemonClub/DB_Table

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

28 Commits
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

DB_Table

์œ ์ €

๊ธ€

๊ทธ๋ฃน

๋Œ“๊ธ€

๊ธฐ๋Šฅ


์œ ์ €

์œ ์ € ํšŒ์›๊ฐ€์ž…

http://lemontree.dothome.co.kr/pinbox/user/user_create

param desc
user_name ์ด๋ฆ„
user_id ์•„์ด๋””
user_pw ๋น„๋ฐ€๋ฒˆํ˜ธ
user_email ์ด๋ฉ”์ผ
user_sex ์„ฑ๋ณ„ (0 : ๋‚จ์ž, 1 : ์—ฌ์ž)
user_age ๋‚˜์ด
user_phone ์ „ํ™”๋ฒˆํ˜ธ
user_profile ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ
PHONE_FAIL ์ด๋ฏธ ํ•ธ๋“œํฐ ๊ณ„์ • ์žˆ์Œ
EMAIL_FAIL ์ด๋ฏธ ์ด๋ฉ”์ผ ๊ณ„์ • ์žˆ์Œ
ID_FAIL ์ด๋ฏธ ์•„์ด๋”” ๊ณ„์ • ์žˆ์Œ

์œ ์ € ๋กœ๊ทธ์ธ

http://lemontree.dothome.co.kr/pinbox/user/user_login

param desc
user_id ์œ ์ € ์•„์ด๋””
user_pw ์œ ์ € ๋น„๋ฐ€๋ฒˆํ˜ธ
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ

์œ ์ € ์ •๋ณด ๊ฐ€์ ธ์˜ค๊ธฐ

http://lemontree.dothome.co.kr/pinbox/user/user_info

param desc
user_id ์œ ์ € ์•„์ด๋””
return desc
json(LA_USER) LA_USER ํ…Œ์ด๋ธ” ํ™•์ธ
FAIL ์‹คํŒจ

์œ ์ € ํŒ”๋กœ์šฐ

http://lemontree.dothome.co.kr/pinbox/user/user_follow

param desc
user_token ์œ ์ €
target_token ํŒ”๋กœ์šฐ ํ•  ํƒ€๊ฒŸ
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ

์œ ์ € ํŒ”๋กœ์šฐ ์ค‘์ธ์ง€ ํ™•์ธ

http://lemontree.dothome.co.kr/pinbox/user/user_is_following

param desc
user_token ์œ ์ €
target_token ํŒ”๋กœ์šฐ ํ•  ํƒ€๊ฒŸ
return desc
ALREADY_FOLLOW ํŒ”๋กœ์šฐ ์ค‘์ž„
UN_FOLLOW ํŒ”๋กœ์šฐ ์ค‘ ์•„๋‹˜
FAIL ์‹คํŒจ

์œ ์ € ํŒ”๋กœ์šฐ ํ•ด์ œ

http://lemontree.dothome.co.kr/pinbox/user/user_unfollow

param desc
user_id ์œ ์ € ์•„์ด๋””
user_pw ์œ ์ € ๋น„๋ฐ€๋ฒˆํ˜ธ
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ
ALREADY_UNFOLLOW ์ด๋ฏธ ์–ธ ํŒ”๋กœ์šฐ ์ค‘์ž„

์œ ์ € ํŒ”๋กœ์šฐ ํ•ด์ œ

http://lemontree.dothome.co.kr/pinbox/user/user_remove

param desc
user_id ์œ ์ € ์•„์ด๋””
user_pw ์œ ์ € ๋น„๋ฐ€๋ฒˆํ˜ธ
user_phone ์œ ์ € ์ „ํ™”๋ฒˆํ˜ธ
user_email ์œ ์ € ์ด๋ฉ”์ผ
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ
WRONG_ID ์•„์ด๋”” ๋˜๋Š” ๋น„๋ฐ€๋ฒˆํ˜ธ๊ฐ€ ํ‹€๋ฆผ

โ€ป ๋ณธ ๊ธฐ๋Šฅ์„ ์‚ฌ์šฉํ•˜๊ธฐ ์ „์— #room_unjoin ์„ ๋จผ์ € ํ˜ธ์ถœํ•˜๊ณ  SUCCESS ๋ฐ›์•„์˜ฌ ๊ฒƒ


๊ธ€

๊ธ€ ์“ฐ๊ธฐ

http://lemontree.dothome.co.kr/pinbox/bbs/bbs_write

param desc
room_token ๋ฐฉ ํ† ํฐ
content ๋‚ด์šฉ
writer ๊ธ€์“ด์ด ํ† ํฐ
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ

๊ธ€ ๊ฐ€์ ธ์˜ค๊ธฐ

http://lemontree.dothome.co.kr/pinbox/bbs/bbs_bring

param desc
room_token ๋ฐฉ ํ† ํฐ
bbs_idx ๊ฒŒ์‹œ๊ธ€ ๋ฒˆํ˜ธ
return desc
json(๊ธ€์ •๋ณด) PB_BBS ํ…Œ์ด๋ธ”
FAIL ์‹คํŒจ
NOT_FOUND ๊ธ€ ๋ชป์ฐพ์Œ

๊ธ€ ์‚ญ์ œ

http://lemontree.dothome.co.kr/pinbox/bbs/bbs_remove

param desc
room_token ๋ฐฉ ํ† ํฐ
bbs_idx ๊ฒŒ์‹œ๊ธ€ ๋ฒˆํ˜ธ
user_token ๊ธ€์‚ญ์ œ ์š”์ฒญํ•œ ์‚ฌ๋žŒ์˜ ํ† ํฐ
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ
NO_ACCESS ๊ถŒํ•œ ์—†๋Š” ์œ ์ €

๊ธ€ ์ˆ˜์ •

http://lemontree.dothome.co.kr/pinbox/bbs/bbs_rewrite

param desc
bbs_idx ๊ฒŒ์‹œ๊ธ€ ๋ฒˆํ˜ธ
content ๋‚ด์šฉ
user_token ๊ธ€์‚ญ์ œ ์š”์ฒญํ•œ ์‚ฌ๋žŒ์˜ ํ† ํฐ
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ

๊ทธ๋ฃน

๊ทธ๋ฃน ์ƒ์„ฑ

http://lemontree.dothome.co.kr/pinbox/room/room_create

param desc
room_name ๋ฐฉ ์ด๋ฆ„
room_manager ์œ ์ € ํ† ํฐ
room_min_age ์ตœ์†Œ ์—ฐ๋ น ์„ค์ •
room_max_age ์ตœ๋Œ€ ์—ฐ๋ น ์„ค์ •
room_profile ๋ฐฉ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
room_memlimit ๋ฐฉ ์ธ์›์ˆ˜ ์ œํ•œ
room_private ๋ฐฉ ๊ณต๊ฐœ ์—ฌ๋ถ€ (๊ธฐ๋ณธ : false : ๊ณต๊ฐœ)
room_tag_0 ~ 4 ๋ฐฉ ํƒœ๊ทธ๋“ค
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ

๊ทธ๋ฃน ์‚ญ์ œ

http://lemontree.dothome.co.kr/pinbox/room/room_remove

param desc
user_token ์œ ์ € ํ† ํฐ
room_token ๋ฐฉ ํ† ํฐ
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ
CANT_REMOVE ์—†๋Š” ๋ฐฉ ํ† ํฐ์ด๊ฑฐ๋‚˜ ๋งค๋‹ˆ์ €๊ฐ€ ์•„๋‹˜

๊ทธ๋ฃน ์ •๋ณด

http://lemontree.dothome.co.kr/pinbox/room/room_info

param desc
room_token ๋ฐฉ ํ† ํฐ
return desc
json(PB_ROOM) PB_ROOM ํ…Œ์ด๋ธ” ํ™•์ธ
FAIL ์‹คํŒจ

์œ ์ € ๋“ฑ๊ธ‰ ์„ค์ •

http://lemontree.dothome.co.kr/pinbox/room/room_user_rank

param desc
user_token ์œ ์ € ํ† ํฐ
room_token ๋ฐฉ ํ† ํฐ
target_token ๋Œ€์ƒ ํ† ํฐ
rank ๋“ฑ๊ธ‰
return desc
SUCCESS PB_ROOM ํ…Œ์ด๋ธ” ํ™•์ธ
FAIL ์‹คํŒจ
RANK_FAIL ๋ณธ์ธ๋ณด๋‹ค ๋†’์€ ๋“ฑ๊ธ‰์— ์žˆ์Œ

๊ทธ๋ฃน ๊ฐ€์ž…

http://lemontree.dothome.co.kr/pinbox/room/room_join

param desc
user_token ์œ ์ € ํ† ํฐ
room_token ๋ฐฉ ํ† ํฐ
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ
MEM_LIMIT ์ธ์› ์ดˆ๊ณผ
NOT_FOUND_ROOM ์—†๋Š” ๋ฐฉ

๊ทธ๋ฃน ํƒˆํ‡ด

http://lemontree.dothome.co.kr/pinbox/room/room_unjoin

param desc
user_token ์œ ์ € ํ† ํฐ
room_token ๋ฐฉ ํ† ํฐ
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ
NOT_FOUND_ROOM ์—†๋Š” ๋ฐฉ

๊ทธ๋ฃน ์ˆ˜์ •

http://lemontree.dothome.co.kr/pinbox/room/room_rewrite

param desc
room_token ๋ฐฉ ํ† ํฐ
room_name ๋ฐฉ ์ด๋ฆ„
room_min_age ์ตœ์†Œ ์—ฐ๋ น ์„ค์ •
room_max_age ์ตœ๋Œ€ ์—ฐ๋ น ์„ค์ •
room_profile ๋ฐฉ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
room_memlimit ๋ฐฉ ์ธ์›์ˆ˜ ์ œํ•œ
room_private ๋ฐฉ ๊ณต๊ฐœ ์—ฌ๋ถ€ (๊ธฐ๋ณธ : false : ๊ณต๊ฐœ)
room_tag_0 ~ 4 ๋ฐฉ ํƒœ๊ทธ๋“ค
room_greeting ๋ฐฉ ์†Œ๊ฐœ ์ธ์‚ฌ
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ

๋Œ“๊ธ€

๋Œ“๊ธ€ ์“ฐ๊ธฐ

http://lemontree.dothome.co.kr/pinbox/comment/comment_write

param desc
bbs_idx ๊ธ€ idx
content ๋‚ด์šฉ
writer ์ž‘์„ฑํ•œ ์œ ์ € ํ† ํฐ
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ

๋Œ“๊ธ€ ๊ฐ€์ ธ์˜ค๊ธฐ

http://lemontree.dothome.co.kr/pinbox/comment/comment_bring

param desc
bbs_idx ๊ธ€ idx
return desc
json(PB_COMMENT) PB_COMMENT ํ…Œ์ด๋ธ” ํ™•์ธ
FAIL ์‹คํŒจ
NOT_FOUND ๋Œ“๊ธ€ ์—†์Œ

๋Œ“๊ธ€ ์‚ญ์ œ

http://lemontree.dothome.co.kr/pinbox/comment/comment_remove

param desc
comment_idx ๋Œ“๊ธ€ idx
user_token ๊ธ€์‚ญ์ œ ์š”์ฒญํ•œ ์‚ฌ๋žŒ์˜ ํ† ํฐ
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ
NO_ACCESS ๊ถŒํ•œ ์—†๋Š” ์œ ์ €

๋Œ“๊ธ€ ์ˆ˜์ •

http://lemontree.dothome.co.kr/pinbox/comment/comment_rewrite

param desc
bbs_idx ๊ธ€ idx
content ๋‚ด์šฉ
writer ์ž‘์„ฑํ•œ ์œ ์ € ํ† ํฐ
return desc
SUCCESS ์„ฑ๊ณต
FAIL ์‹คํŒจ

๊ธฐ๋Šฅ

ํƒ€์ž„๋ผ์ธ

http://lemontree.dothome.co.kr/pinbox/edition/timeline

param desc
user_id ์œ ์ € ์•„์ด๋””
bbs_idx ๊ธ€ idx
return desc
json(PB_BBS) PB_BBS ํ…Œ์ด๋ธ” ํ™•์ธ
FAIL ์‹คํŒจ

About

No description or website provided.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors