-
Notifications
You must be signed in to change notification settings - Fork 0
`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 | | +---------+--------------+------+-----+---------+----------------+ `