게시판의 DB 스키마

현재 주소 복사
트랙백 주소 복사
방실이님의 글 (8/28/2007 3:42:11 PM) Viewing : 26843

음..
먼저 아래 이미지를 살펴 보도록 하겠다.

클릭하시면 더 큰 그림으로..OK??

총 7개의 테이블이 보인다.
하나씩 천천히 대충 살펴 보도록 하겠다.

 

  • BoardCategory  - 이 스키마의 최상의 테이블이다. 게시판의 정보를 가지고 있다. 게시판의 서브카테고리를 가지고 있는지 판별하는 bool 형의 컬럼이 있으며 나머지 컬럼들은 직관적이다.
  • BoardPermission - AccountsRoles 테이블의 참조를 받아 해당 역할에 따른 게시판의 권한 설정부분이다. 게시물읽기, 쓰기, 파일 다운로드, 게시물리스트보기, 답변달기의 권한 설정이 있다.
  • BoardPostCategory - 게시판의 서브카테고리이다.
  • BoardBase - 게시물에 대한 테이블이다. UserName은 사용자친화적인 아이디이며 RealName은 사용자의 실명이며 나머지는 패스..한다.
  • BoardRecommend - 게시물에 대한 추천관련한 테이블인데..미구현이다..ㅡ.ㅡ;...이런 귀차니즘이...ㅡ.ㅠ
  • BoardComment - 해당 게시물에 상응하는 댓글에 대한 테이블이다. 미로그인자도 입력을 받기 위해 UserName과 RealName, Password 모두 받는다.
  • BoardFile - 마지막으로 업로드된 파일에 대한 정보 테이블이다, 파일에 대한 기본 정보를 저장하며 업로드한 파일의 원본은 RealName에 저장하며 임의로 할당된 GUID 형식의 이름은 VirtualName에 정의되고 실제 파일서버에는 VirtualName의 파일이 업로드 된다. 보안상..^^;

이 게시판은 계층형 게시판이며 계층형게시판의 알고리즘은 http://taeyo.net/ 의 것을 참고 하였다.
코드를 보기 전에 먼저 계층형 게시판의 이론을 숙지 하기 바란다..

그리고 페이징의 구현은 RowCount방식을 선정하였다. 
페이징의 방식에 따라 쿼리문과 페이저의 코드가 달라질수 있다.

RowCount방식의 페이징 구현은 아래 링크를 참고 한다.
http://www.codeproject.com/aspnet/PagingLarge.asp


마지막 업데이트 : (8/29/2007 9:52:03 AM)

TAG : 없음



Trackback 보기 (0)
댓글 보기 (4)
BloomcixRX님의 글 (12/15/2020 8:02:41 PM)
Whenever you are attempting to search out immediately, economical tailored essays then glimpse no a lot more compared to common creator. You might have headache finding knowledgeable who gives these a service. You'll find many strategies regarding how to get acquire about the minimum costly expert writers available [url=
http://webunderconstruction.nl/personnel-a-solid-expert-competent-dissertation/]correlation[/url]. Down below is precisely what you need to do.

Vital in a matter these as "get cost-effective personalised essay writers" and strike the enter button. You may see an inventory of websites by yourself hunt for achievements web-site or concerning the preliminary handful of web content.

Probably the most advantageous strategy to conquer out troubles and generate a significant good quality writing service a productive entity is through earning a high quality alternative like higher education or college essays. It might help you save you time from the usage of a writer with performing expertise along with your field which might be the only way you may uncover high quality writing that fulfills your would like. Remember, you need to do not need to have a writer who does very low price work, you should like a terrific writer who'll give you a superb rate on top of that to your great creator that's also an exceedingly superior creator.

It really is not a knock on low-priced writers, but I am trying to get to say you can find a difference involving a signify creator too as being a superb one particular certain. You want a significant widespread which means you also have to be able to shell out an easily affordable price and acquire your do the work as you need it most. An extremely excellent writer should not price a fantastic offer pounds, having said that they should really actually provide you with their concentrate on a fast turnaround and also you only should not have to hold out close to to acquire a extended time-frame to attain your designed assignment [url=
http://blog.edpowers.com/2020/10/methods-to-write-my-essay-by-using-organisation/]website url[/url].

Heaps of very low price tag custom made essay writers will need with the hour, but this will present you having a emotion of urgency just simply because they may be accomplishing not know should really they will get your function completed. You may only know for individuals who have acquired your operate any time you definitely really have to modify it in which isn't a good feeling.

It can be definitely finest to hire a specialist writing service, even so, if it is possible to purchase an individual, this will be gonna be the very best decision given that they are intending to current you along with the rather simplest services and products. You'll want to make sure the service you may be using is respected given that they've way more doing the job encounter than numerous individuals. they have to control a whole lot extra learners, so that they make use of a a good deal much extra in depth information of regardless of what they must do and should make tips about the way to go about ending the assignment.

It is also achievable to exam to ascertain the volume of higher education pupils they could have managed and precisely how quite a few times they have obtained been utilized as customers by a writer ahead of choosing to decide to put into action them. This can be typically somewhat a little something to ponder forward of choosing anyone thanks for the reality this could be an indicator of how liable the creator is. If a writer has numerous clientele these are generally excess more than likely to be a trustworthy creator, which means they may be an unbelievable experienced as well as have sensible encounter doing with school pupils and you simply just wish to have the position performed owning a trusted creator [url=
http://markvaerk.thehildebrand.com/2020/08/13/the-stuff-that-could-you-do-to-master-who-ll/]interconnection[/url].

Also, hunt for corporations which happen to be completely ready to ship out samples within their do the work being confident your gratification along with your picking, what this means is you are specified they could generate a concluded goods as an alternative of be frightened to reply any queries you could possibly perhaps have. A lot of these types of firms give a refund assures by themselves perform so it really is a amazing solution to be certain that you are content with their do the work. It is best to use the service of a writer which is able to support you out in these locations and likewise you pick to get swiftly individualized essay writers on the assignment [url=
http://ausband.com.au/modules.php?name=Your_Account&op=userinfo&username=reynapeters]affiliation[/url].

Remember there are actually many writers that provide writing methods in Chicago, which suggests you would want to examine out with them comprehensively before choosing to decide on a corporation to lease [url=
http://balonynadhradem.cz/tips-on-how-to-publish-a-cover-letter-in-depth/]affiliate connection[/url]. It truly is critical to find a writer that may be adaptable and well prepared to perform coupled with you to make sure that you could function jointly. you can manage to get there up by making use of a top-quality writing schedule and do the work along with a single a different obtain the best obstacle to fit your wants.

Assure the creator you utilize the service of offers proofread and modifying answers. A fast individualized essay is a crucial part within the posted assignment, which implies you must have to provide completely certain the creator is proficient with proofreading and modifying. This will likely make sure you may perhaps get an error-free assignment.

Typically get hold of a deadline around the assignment meaning you know for those who have to have to complete it thanks to your point deadlines must have to be effectively timed. you may want to have your perform attained inside of a perfectly timed trend, but you should not established too quite a bit drive on your self simply just simply because you will find gonna be a superb offer of other details to trouble with at receive the position finished.



JoshuaknopsFV님의 글 (1/9/2021 11:39:04 AM)
[URL=https://www.insnecklace.com/]engraved necklace[/URL]
[URL=https://www.insnecklace.com/]custom bracelets[/URL]

Seed Pearl Popularity Dates Back To The 18Th Century

One can still wear it in your next years arrive. I draped the necklace over the cookies and sealed upward. Have your name written and properly spelled in silver. Lower 14 inches and the pendant can crowd the neckline.

Did kind of person it's possible to create and customize individual personal medical anklet bracelets? All you have to do is go and also mix and match! Whether you need to customize one for yourself or for almost any loved one, you understand the process to be very enjoyable and enjoyment. It's also simple and easy. You will add your favorite symbol thats got any words you want engraved in it. There are a lot of different styles, colors, and also to choose from. Whoever thought medical bracelets could make such a fashion epitome of fashion?

The growing trend in jewelry is having it personalized such being a name necklace. Today, so many Hollywood stars like Jennifer Lopez are showcasing their personalized jewelry; and it has even become fashionable among the public to use a copy of their signature charms. While some prefer to wear fashion jewelry with the favorite actresses and singers, many also proudly wear their own necklace that reads their name attached to it. Indeed, one of the best gifts to get someone you like is a personalised necklace. Please read on to understand why getting a nameplate necklace should be one from the first ways to consider when thinking that are of a great bonus.

As seem for personalized necklaces, you will find that these people are typically along with silver and gold. The letter is actually written by the crafter an individual also can choose from different lettering types. Yes, there plenty of resource material of lettering types a person choose from, you can select script, block and etc. Actually, you get not only name necklaces but might get earrings and bracelets as very. You can get necklace, bracelet and earrings and show off your name anywhere an individual.

The 125West Ruby currently is for sale and would probably produce many amazing stones for crafting custom . Its estimated value is currently unfamiliar.

Then, although it was rice, I went to a Chinese restaurant but happened to be a take-out container and had them fill it with fortune cookies. I draped the necklace the actual cookies and sealed upward.

As common history implies, the 28 to 34 inch Opera length is worthwhile for adding sophistication to sophisticated gown or blouse. The space naturally pulls the eyes down custom necklaces on to the chest. By be ideal if your bust lines are more flattering than your neckline. Be sure, though, that your bra is every bit as complimentary.

There a wide range of other great gift ideas that are original. You can ask a vendor to fill a gift basket to the brim with unique baby gifts which usually also practical. For a baby shower, diaper cakes are beautiful yet practical gifts that new parents will really enjoy. A diaper cake is a unique baby gift that can double to be a centerpiece too. If you are on a tight budget, nappy cupcakes tend to be simply as beautiful and useful. Baby bouquets made of colorful baby clothes rolled into a flower shape are also very popular nowadays.

Baskets are a need to have every non commercial. Without them, clothes can pile up on the floor, chairs, tables, and many more. You can't have that many hooks in a lot of things to hang used clothes on, suitable? Having laundry baskets is recommended then. Including this day and age, you should add removable canvas inserts to increase convenience to your gathering and transport of laundry.

Pearl necklace costume jewelry has become very popular recently in which really nice for market . don't possess a budget that includes real or cultured spheres. There are many kinds of quality pearl necklaces that you must know about when you are prepared to invest in unique.

As the name necklace implies, the 28 to 34 inch Opera length is excellent for adding sophistication to a proper gown or blouse. The space naturally pulls the eyes down for ones chest. Take out joints . be ideal if your bust lines are more flattering than your neckline. Be sure, though, that your bra is equally complimentary.

You may starting to think about ways how to make your mom feel her worth. You can simply ask her to relax a bit about web site to property. This means that you will have to take charge of all house concerns like cleaning, doing the dishes and other domestic wants. This is a simple involving giving her a break of all the worries both at home and you likewise letting her feel you are sure of that is actually having a difficult time and you need to share that burden.

Personalized and unique baby gift items are excellent a baby shower party or even a first birthday bash. If you want something special that is original and different, you can choose personalized necklaces, designer diaper bags, deluxe baby baskets, personalized blankets and a good many more. A homemade gift is not just unique but this baby gift from the heart may have a sentimental value which priceless. A homemade scrapbook, knitted booties or handmade baby blanket will remain aware of treasured from parents.

Majority of this women prefer buying ready-made jewelry. Is actually a huge variety of jewelry sets available a market yet they cannot take wounds of handmade jewelry. On the earth ! thing is actually ready-made jewelry is highly expensive the reason why should we waste our money within this jewelry all of us can make it at home? Yes, it is right; we can easily design custom necklaces jewelry at domestic. In fact, homemade jewelry looks more beautiful than ordinary gems.

If ensure search, manage to gain to find various designs of charm appeal. You can even ask for something personalized so that you can truly think of it your exclusive. The maker can give you a charm necklace that has your name on thought. Birthstones can also be added on the piece. Many of these necklaces are hand produced. Hence, you can be sure that it is a fine piece and somebody made how you really enjoy.

So fall your choices if you're considering what to execute with your unloved gold jewelry. Sure, you could just take the cash and run, around the might a little more fun create something likewise allows be uniquely yours. Not only is such a type of recycling good for the environment, however it's also easy on the wallet. Maybe you can turn your old gold into an important piece of custom jewelry, such like a wedding ring or a sacramental keepsake cross to one's child's holy communion, or merely you'll just create a surprising one-of-a-kind statement piece that will surely work as envy most your shut. Whatever you decide to do to your old gold, you'll know that it served a purpose other than merely putting some spare put on your safety pocket. It was recycled into a shiny new piece of custom .
[URL=https://www.insnecklace.com/mothers-day-necklace-for-mothers-day/]mothers day jewelry[/URL]
[URL=https://www.insnecklace.com/18-tips-for-choosing-an-infinity-ring/]white gold infinity ring[/URL]



BillyValFK님의 글 (1/11/2021 3:13:30 AM)
Привет
Если у кого то есть проблемы с мужским здоровьем то заходите по ссылке
Сиалис Приобрести с доставкой. Загляните на наш сайт

http://bit.ly/2PER9Fs


1e9c1a255f36442aa274ee111a22155c



댓글 쓰기

Board 개요

현재 주소 복사
트랙백 주소 복사
방실이님의 글 (8/28/2007 3:23:29 PM) Viewing : 2985
참으로 오랜만에.....ㅡ.ㅡ;;;

소스를 오픈하는 듯 하다..
그렇다구 해서 수정이 있었던 것은 아니다.
단지 게을러서일뿐..ㅡ.ㅠ;

아직 부족한 부분이 많지만

비기너분들이 참고하기에는 그럭저럭 기본빵...ㅇㅇ???

다음 게시물에서 DB 구조부터 살펴 보도록 하겠다.

마지막 업데이트 : (8/28/2007 3:23:29 PM)

TAG : 없음



첨부 파일 보기 (1)
Trackback 보기 (0)
댓글 보기 (2)
정기욱님의 글 (2/5/2008 5:45:53 PM)
우와 -ㅁ- cs코드만 잔뜩있는데.... 어렵내요.흉내좀 내볼라고 했더니 ..에효



이재원님의 글 (4/16/2009 11:00:56 AM)
좋은 내용 고맙습니다. ^^



댓글 쓰기



<< < 1 > >>