-
Notifications
You must be signed in to change notification settings - Fork 0
woosoo2 edited this page Mar 7, 2014
·
3 revisions
mysql> desc member;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| mid | varchar(20) | NO | PRI | NULL | |
| pw | varchar(40) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
mysql> desc closet;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| cid | int(11) | NO | PRI | NULL | auto_increment |
| cname | varchar(20) | YES | | NULL | |
| mid | varchar(20) | YES | MUL | NULL | |
+-------+-------------+------+-----+---------+----------------+
mysql> desc ccgrp;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| cid | int(11) | NO | PRI | 0 | |
| csid | int(11) | NO | PRI | 0 | |
+-------+---------+------+-----+---------+-------+
mysql> desc codyset;
+--------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+----------------+
| csid | int(11) | NO | PRI | NULL | auto_increment |
| tid | int(11) | YES | MUL | NULL | |
| bid | int(11) | YES | MUL | NULL | |
| csname | varchar(40) | YES | | NULL | |
+--------+-------------+------+-----+---------+----------------+
mysql> desc top;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| tid | int(11) | NO | PRI | NULL | auto_increment |
| tname | varchar(40) | YES | | NULL | |
| sex | varchar(10) | YES | | NULL | |
| tmn | int(11) | YES | | NULL | |
| tmx | int(11) | YES | | NULL | |
| style | varchar(10) | YES | | NULL | |
| price | int(11) | YES | | NULL | |
| size | varchar(30) | YES | | NULL | |
| t_url_1 | varchar(200) | YES | | NULL | |
| t_url_2 | varchar(200) | YES | | NULL | |
+---------+--------------+------+-----+---------+----------------+
mysql> desc bot;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| bid | int(11) | NO | PRI | NULL | auto_increment |
| bname | varchar(40) | YES | | NULL | |
| sex | varchar(10) | YES | | NULL | |
| tmn | int(11) | YES | | NULL | |
| tmx | int(11) | YES | | NULL | |
| style | varchar(10) | YES | | NULL | |
| price | int(11) | YES | | NULL | |
| size | varchar(30) | YES | | NULL | |
| b_url_1 | varchar(200) | YES | | NULL | |
| b_url_2 | varchar(200) | YES | | NULL | |
+---------+--------------+------+-----+---------+----------------+