처음에 게시판 DB구조를 짰을때 구조입니다 <div><br></div> <div>전체 게시판에 모든 정보가 들어있고(ALL_FORUM)<br><table border="1" width="100%" cellpadding="3" cellspacing="0" style="border-style:solid;border-collapse:collapse;"><tbody><tr><td> ALL_FORUM(id)</td> <td> kind</td> <td> title</td> <td> content</td></tr><tr><td> 4</td> <td> free</td> <td> aaaaaa14</td> <td> free2</td></tr><tr><td> 3</td> <td> game</td> <td> dddd24</td> <td> game1</td></tr><tr><td> 2</td> <td> fun</td> <td> ccccc123</td> <td> fun1</td></tr><tr><td> 1</td> <td> free</td> <td> bbbbb3</td> <td> free1</td></tr></tbody></table><br><br>전체게시판의 id를 각 종류게시판으로 뿌려줍니다<br><div><table border="1" width="100%" cellpadding="3" cellspacing="0" style="border-style:solid;border-collapse:collapse;"><tbody><tr><td> free_FORUM(id)</td> <td> kindid</td></tr><tr><td> 2</td> <td> 4</td></tr><tr><td> 1</td> <td> 1</td></tr></tbody></table><br></div> <div><table border="1" width="100%" cellpadding="3" cellspacing="0" style="border-style:solid;border-collapse:collapse;"><tbody><tr><td> fun_FORUM(id)</td> <td> kindid</td></tr><tr><td> 1</td> <td> 2<br></td></tr></tbody></table><br></div> <div><table border="1" width="100%" cellpadding="3" cellspacing="0" style="border-style:solid;border-collapse:collapse;"><tbody><tr><td> game_FORUM(id)</td> <td> kindid</td></tr><tr><td> 1</td> <td>3</td></tr></tbody></table><br></div> <div>이렇게 한 이유는 각 게시판별로 전체글보기가 아닌 free보드만들어갔을때 free보드의 id값으로 정렬하고싶어서입니다.</div> <div><br></div> <div>그러다가</div> <div><br></div> <div>한곳에 정보가 다 있으면 안될것같아서 가지고있는 정보들을 각 종류게시판들이 각각가지고있고</div> <div><br></div> <div>ALL_FORUM에는 각게시판의 종류와 id값만 가지고있습니다</div> <div><table border="1" width="50%" cellpadding="3" cellspacing="0" style="border-spacing:0px;border-collapse:collapse;background-color:transparent;color:#333333;font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;font-size:12px;border-style:solid;"><tbody><tr><td style="font-size:9pt;line-height:21.6px;padding:0px;"> ALL_FORUM(id)</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> KIND</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> KIND_ID</td></tr><tr><td style="font-size:9pt;line-height:21.6px;padding:0px;"> 4</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> free</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> 2</td></tr><tr><td style="font-size:9pt;line-height:21.6px;padding:0px;"> 3</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> game</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> 1</td></tr><tr><td style="font-size:9pt;line-height:21.6px;padding:0px;"> 2</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> fun</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> 1</td></tr><tr><td style="font-size:9pt;line-height:21.6px;padding:0px;"> 1</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> free</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> 1</td></tr></tbody></table><div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;color:#333333;"><br></div> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;">그런다음 종류게시판별로 자신들이 가지고있는 글정보를 가지고있는거죠</div> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;color:#333333;"> <table border="1" width="50%" cellpadding="3" cellspacing="0" style="border-spacing:0px;border-collapse:collapse;background-color:transparent;border-style:solid;"><tbody><tr><td style="font-size:9pt;line-height:21.6px;padding:0px;"> free_FORUM(id)</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> title</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> content</td></tr><tr><td style="font-size:9pt;line-height:21.6px;padding:0px;"> 2</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> aaaaaa14</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> free2</td></tr><tr><td style="font-size:9pt;line-height:21.6px;padding:0px;"> 1</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> bbbbb3</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> free1</td></tr></tbody></table><br></div> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;color:#333333;"> <table border="1" width="50%" cellpadding="3" cellspacing="0" style="border-spacing:0px;border-collapse:collapse;background-color:transparent;border-style:solid;"><tbody><tr><td style="font-size:9pt;line-height:21.6px;padding:0px;"> fun_FORUM(id)</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> title</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> content</td></tr><tr><td style="font-size:9pt;line-height:21.6px;padding:0px;"> 1</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> ccccc123</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> fun1</td></tr></tbody></table><br></div> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;color:#333333;"> <table border="1" width="50%" cellpadding="3" cellspacing="0" style="border-spacing:0px;border-collapse:collapse;background-color:transparent;border-style:solid;"><tbody><tr><td style="font-size:9pt;line-height:21.6px;padding:0px;"> game_FORUM(id)</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> title</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> content</td></tr><tr><td style="font-size:9pt;line-height:21.6px;padding:0px;"> 1</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> dddd24</td> <td style="font-size:9pt;line-height:21.6px;padding:0px;"> game1<br><br></td></tr></tbody></table><br></div></div></div> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;">그래서 이러한 구조가나왔는데 제생각이 맞는지 질문드리고싶습니다.....</div> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;"><br></div> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;">오유처럼 전체글이있고 각 종류게시판별로있다고했을때</div> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;"><br></div> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;">첫번째구조와 두번째구조중에서 어떤게 맞는걸까요?</div> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;"><br></div> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;">제 생각은 게시판별로 정보를 가지고있어야지 특정게시판이 날아가도 다른게시판의 정보가 여전히 있을것같아서 DB구조를바꾼건데요</div> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;">첫번째의 경우 ALL테이블이 날아가버리면 게시글이 다날아가버리니...</div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.