Messageboard Database Design

Version 0.5 - tim@hoop.co.uk - 1999/03/22

 

Contents:

  1. Introduction
  2. MessageBoards
  3. Messages
  4. Users
  5. Users/Boards

 

1. Introduction

This document defines the datastructure for use with the PanerisII messageboards. An id field is implied for all tables.

Please comment.

 

2. Messageboards

This table holds information on messageboards.

Field Type Length
name varchar 50
description varchar 255
display order int 4
deleted boolean  

 

3. Messages

This table holds information on messages:

Field Type Length
board lookup (messageboards)  
date date  
subject varchar 255
author lookup (users)  
parent int 8
content text  
deleted boolean  

 

 

4. Users

This table holds information on messageboard users. I imagine that it will become the table holding generic user data for the entire PanerisII system. I have decided to not do too much analysis, and have restricted myself to what is required for the Messageboards (this is also all we store in the current pms):

Field Type Length
name varchar 50
email varchar 50

 

 

5. Users/Messageboards

An entry in this table means that the given user us subscribed to the given messageboard.

Field Type Length
user lookup (users)  
messageboard lookup (messageboard)  

 

Document Dated: Fri Mar 15 11:07:00 1999
Modify this document