|
아래의 테이블은 저희 사이트에서 사용중인것입니다.
미흡한 제가 만든것이지요...
지금까지 잘 써왔는데. 요즘들어 많이 작살납니다.
문제가 뭔지 알기라도 한다면 속이라도 좀 시원할텐데...
show tables;
Tables in lamusica |
| auction |
| auction2 |
| board |
| bookreview |
| bookstore |
| counter |
| email |
| member |
| orders |
| owmail |
| product |
| reser |
| review |
13 rows in set (0.01 sec)
mysql> desc auction
-> ;
| Field | Type | Null | Key | Default | Extra |
| pid | bigint(20) | | | 0 | |
| sday | int(20) | | | 0 | |
| eday | int(20) | | | 0 | |
| userid | varchar(20) | | | | |
| email | varchar(50) | | | | |
| sprice | int(20) | | | 0 | |
| shipprice | varchar(20) | YES | | NULL | |
| nprice | int(20) | YES | | NULL | |
| artist | varchar(100) | | | | |
| title | varchar(100) | | | | |
| grp | varchar(40) | YES | | NULL | |
| cdlp | varchar(20) | YES | | NULL | |
| state | varchar(20) | YES | | NULL | |
| track | text | YES | | NULL | |
| content | text | YES | | NULL | |
| view | varchar(10) | YES | | NULL | |
| cnt | int(11) | YES | | NULL | |
17 rows in set (0.00 sec)
mysql> desc auction2;
| Field | Type | Null | Key | Default | Extra |
| pid | bigint(20) | YES | | NULL | |
| aid | int(20) | YES | | NULL | |
| userid | varchar(20) | YES | | NULL | |
| email | varchar(50) | YES | | NULL | |
| nprice | int(20) | YES | | NULL | |
| state | varchar(10) | YES | | NULL | |
+--------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql> auct desc board;
| Field | Type | Null | Key | Default | Extra |
| id | int(11) | | | 0 | |
| nm | varchar(10) | | | | |
| pw | varchar(10) | YES | | NULL | |
| em | varchar(40) | YES | | NULL | |
| tt | varchar(100) | | | | |
| ct | text | | | NULL | |
| dt | int(11) | | | 0 | |
| cn | int(11) | | | 0 | |
| rc | varchar(5) | YES | | NULL | |
| db | varchar(10) | | | | |
10 rows in set (0.00 sec)
mysql> desc bookstore;
| Field | Type | Null | Key | Default | Extra |
| isbn1 | int(11) | | | 0 | |
| isbn2 | int(11) | | | 0 | |
| isbn3 | varchar(4) | YES | | NULL | |
| subject | varchar(255) | | | | |
| image | varchar(100) | YES | | NULL | |
| price | int(11) | YES | | NULL | |
| writed | varchar(100) | | | | |
| translator | varchar(100) | YES | | NULL | |
| occupation | varchar(100) | YES | | NULL | |
| made | varchar(20) | YES | | NULL | |
| page | int(11) | | | 0 | |
| contents | text | YES | | NULL | |
| recommend | text | YES | | NULL | |
| note | text | YES | | NULL | |
| translate | varchar(20) | YES | | NULL | |
| class | varchar(20) | YES | | NULL | |
| register | int(11) | | | 0 | |
| review | int(11) | YES | | NULL | |
| view | varchar(10) | YES | | NULL | |
| ordr | int(11) | | | 0 | |
20 rows in set (0.00 sec)
mysql> desc bookstore;
| Field | Type | Null | Key | Default | Extra |
| isbn1 | int(11) | | | 0 | |
| isbn2 | int(11) | | | 0 | |
| isbn3 | varchar(4) | YES | | NULL | |
| subject | varchar(255) | | | | |
| image | varchar(100) | YES | | NULL | |
| price | int(11) | YES | | NULL | |
| writed | varchar(100) | | | | |
| translator | varchar(100) | YES | | NULL | |
| occupation | varchar(100) | YES | | NULL | |
| made | varchar(20) | YES | | NULL | |
| page | int(11) | | | 0 | |
| contents | text | YES | | NULL | |
| recommend | text | YES | | NULL | |
| note | text | YES | | NULL | |
| translate | varchar(20) | YES | | NULL | |
| class | varchar(20) | YES | | NULL | |
| register | int(11) | | | 0 | |
| review | int(11) | YES | | NULL | |
| view | varchar(10) | YES | | NULL | |
| ordr | int(11) | | | 0 | |
20 rows in set (0.00 sec)
mysql> desc counter;
| Field | Type | Null | Key | Default | Extra |
| yr | int(11) | YES | | NULL | |
| mh | int(11) | YES | | NULL | |
| dy | int(11) | YES | | NULL | |
| wk | varchar(10) | YES | | NULL | |
| hr | int(11) | YES | | NULL | |
| mn | int(11) | YES | | NULL | |
| sc | int(11) | YES | | NULL | |
| at | varchar(100) | YES | | NULL | |
| ht1 | int(11) | YES | | NULL | |
| ht2 | int(11) | YES | | NULL | |
| ht3 | int(11) | YES | | NULL | |
| ht4 | int(11) | YES | | NULL | |
| db | varchar(20) | YES | | NULL | |
13 rows in set (0.00 sec)
|
