# Mysql table :look at:

**URL:** <https://forum.kirupa.com/t/mysql-table-look-at/230269>\
**Category:** Uncategorized\
**Created:** [June 24, 2007, 11:09pm UTC](https://forum.kirupa.com/t/mysql-table-look-at/230269 "2007-06-24T23:09:51Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Utech22](https://avatars.discourse-cdn.com/v4/letter/u/f17d59/32.png) [@Utech22](https://forum.kirupa.com/u/Utech22)\
**Post date:** [June 24, 2007, 11:09pm UTC](https://forum.kirupa.com/t/mysql-table-look-at/230269/1 "2007-06-24T23:09:51Z")

</div>

I am creating a database \*(as a backend to a website) \*  
here are the tables and feilds, how does it look?

## Student

```auto
 
fieldname Size datatype
id 10 int primary key 
title 3 varchar
firstname 20 varchar 
lastname 20 varchar
age 2 int
phone 9 int
parish 30 varchar
email 50 varchar

```

## Programme

```auto
 
fieldname Size datatype
programmeid autoincrement primary key
programmename 30 varchar
id 10 int
qualification 20 varchar
graduateyear 4 int

```

## Employment

```auto
 
Fieldname size datatype
employeeid autoincrement primary key
id 10 int
employmentplace 50 varchar
status 20 varchar

```

## Username

```auto
 
Fieldname size datatype
username 30 varchar
password 30 varchar

```

[slicDiggy](http://www.kirupa.com/forum/member.php?u=56064) help out!!