mysql> show tables;
+----------------+
| Tables_in_dasr |
+----------------+
| agbed          |
| bedfile        |
| experiment     |
| genome         |
| method         |
| rawbed         |
| researcher     |
| summarybed     |
+----------------+

mysql> describe bedfile;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| bedfile_id    | int(11)      | NO   | PRI | NULL    | auto_increment |
| experiment_id | int(11)      | NO   |     | NULL    |                |
| method_id     | int(11)      | NO   |     | NULL    |                |
| genome_id     | int(11)      | NO   |     | NULL    |                |
| filetype      | varchar(32)  | YES  |     | NULL    |                |
| name          | varchar(128) | NO   |     | NULL    |                |
| upload_date   | datetime     | NO   |     | NULL    |                |
| expiration    | datetime     | YES  |     | NULL    |                |
| header        | text         | YES  |     | NULL    |                |
| descr         | varchar(255) | YES  |     | NULL    |                |
+---------------+--------------+------+-----+---------+----------------+

mysql> describe rawbed;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| rawbed_id  | int(11)      | NO   | PRI | NULL    | auto_increment |
| bedfile_id | int(11)      | NO   |     | NULL    |                |
| filepath   | varchar(128) | NO   |     | NULL    |                |
+------------+--------------+------+-----+---------+----------------+

mysql> describe summarybed;
+---------------+---------------+------+-----+---------+----------------+
| Field         | Type          | Null | Key | Default | Extra          |
+---------------+---------------+------+-----+---------+----------------+
| summarybed_id | int(11)       | NO   | PRI | NULL    | auto_increment |
| bedfile_id    | int(11)       | NO   |     | NULL    |                |
| chrom         | varchar(8)    | NO   |     | NULL    |                |
| chromstart    | bigint(20)    | NO   |     | NULL    |                |
| chromend      | bigint(20)    | NO   |     | NULL    |                |
| name          | varchar(32)   | YES  |     | NULL    |                |
| score         | int(11)       | YES  |     | NULL    |                |
| strand        | enum('+','-') | YES  |     | NULL    |                |
| thickstart    | bigint(20)    | YES  |     | NULL    |                |
| thickend      | bigint(20)    | YES  |     | NULL    |                |
| itemrgb       | varchar(16)   | YES  |     | NULL    |                |
| remainder     | text          | YES  |     | NULL    |                |
| blockcount    | bigint(20)    | YES  |     | NULL    |                |
| blocksizes    | varchar(32)   | YES  |     | NULL    |                |
| blockstarts   | varchar(32)   | YES  |     | NULL    |                |
+---------------+---------------+------+-----+---------+----------------+

mysql> describe agbed;
+-------------+---------------+------+-----+---------+----------------+
| Field       | Type          | Null | Key | Default | Extra          |
+-------------+---------------+------+-----+---------+----------------+
| agbed_id    | int(11)       | NO   | PRI | NULL    | auto_increment |
| bedfile_id  | int(11)       | NO   |     | NULL    |                |
| chrom       | varchar(8)    | NO   |     | NULL    |                |
| chromstart  | bigint(20)    | NO   |     | NULL    |                |
| chromend    | bigint(20)    | NO   |     | NULL    |                |
| name        | varchar(32)   | YES  |     | NULL    |                |
| score       | int(11)       | YES  |     | NULL    |                |
| strand      | enum('+','-') | YES  |     | NULL    |                |
| thickstart  | bigint(20)    | YES  |     | NULL    |                |
| thickend    | bigint(20)    | YES  |     | NULL    |                |
| itemrgb     | varchar(16)   | YES  |     | NULL    |                |
| remainder   | text          | YES  |     | NULL    |                |
| blockcount  | bigint(20)    | YES  |     | NULL    |                |
| blocksizes  | varchar(32)   | YES  |     | NULL    |                |
| blockstarts | varchar(32)   | YES  |     | NULL    |                |
+-------------+---------------+------+-----+---------+----------------+


mysql> describe experiment;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| experiment_id | int(11)      | NO   | PRI | NULL    | auto_increment |
| title         | varchar(128) | NO   |     | NULL    |                |
| researcher_id | int(11)      | YES  |     | NULL    |                |
| exp_date      | datetime     | NO   |     | NULL    |                |
| create_date   | datetime     | NO   |     | NULL    |                |
| keywords      | text         | YES  |     | NULL    |                |
| description   | text         | YES  |     | NULL    |                |
| bedcount      | int(11)      | YES  |     | NULL    |                |
+---------------+--------------+------+-----+---------+----------------+


mysql> describe genome;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| genome_id     | int(11)      | NO   | PRI | NULL    | auto_increment |
| name          | varchar(64)  | NO   | UNI | NULL    |                |
| chromosomes   | varchar(255) | YES  |     | NULL    |                |
| researcher_id | int(11)      | YES  |     | NULL    |                |
+---------------+--------------+------+-----+---------+----------------+

mysql> describe method;
+-----------+-------------+------+-----+---------+----------------+
| Field     | Type        | Null | Key | Default | Extra          |
+-----------+-------------+------+-----+---------+----------------+
| method_id | int(11)     | NO   | PRI | NULL    | auto_increment |
| name      | varchar(64) | NO   | UNI | NULL    |                |
+-----------+-------------+------+-----+---------+----------------+

mysql> describe researcher;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| researcher_id | int(11)      | NO   | PRI | NULL    | auto_increment |
| email         | varchar(128) | YES  |     | NULL    |                |
| firstname     | varchar(64)  | YES  |     | NULL    |                |
| lastname      | varchar(64)  | YES  |     | NULL    |                |
| username      | varchar(32)  | NO   | UNI | NULL    |                |
| pword         | varchar(32)  | NO   |     | NULL    |                |
+---------------+--------------+------+-----+---------+----------------+