mysql>
mysql>
mysql> show tables;
+-------------------+
| Tables_in_appledb |
+-------------------+
| aaa               |
| admin             |
| bd_02             |
| bd_3              |
| board             |
| board1            |
| cart              |
| member            |
| memo              |
| mymemo            |
| product           |
| result            |
| zipcode1          |
+-------------------+
13 rows in set (0.00 sec)

mysql> desc aaa;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| aaa   | varchar(10) |      |     |         |       |
+-------+-------------+------+-----+---------+-------+
1 row in set (0.00 sec)

mysql> desc admin;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| adminid   | varchar(20) | YES  |     | NULL    |       |
| adminpass | varchar(20) | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> desc bd_02;
+----------+---------------------+------+-----+---------+----------------+
| Field    | Type                | Null | Key | Default | Extra          |
+----------+---------------------+------+-----+---------+----------------+
| code     | int(10) unsigned    |      | PRI | NULL    | auto_increment |
| bbs_code | varchar(20)         | YES  |     | NULL    |                |
| name     | varchar(20)         | YES  |     | NULL    |                |
| passwd   | varchar(20)         | YES  |     | NULL    |                |
| email    | varchar(50)         | YES  |     | NULL    |                |
| home     | varchar(100)        | YES  |     | NULL    |                |
| title    | varchar(255)        | YES  |     | NULL    |                |
| content  | text                | YES  |     | NULL    |                |
| reg_date | int(10) unsigned    | YES  |     | NULL    |                |
| count    | int(10) unsigned    | YES  |     | NULL    |                |
| ref      | int(10) unsigned    | YES  |     | NULL    |                |
| level    | tinyint(3) unsigned | YES  |     | NULL    |                |
| step     | tinyint(3) unsigned | YES  |     | NULL    |                |
+----------+---------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)

mysql> desc bd_3;
+----------+---------------------+------+-----+---------+----------------+
| Field    | Type                | Null | Key | Default | Extra          |
+----------+---------------------+------+-----+---------+----------------+
| code     | int(10) unsigned    |      | PRI | NULL    | auto_increment |
| bbs_code | varchar(20)         | YES  |     | NULL    |                |
| name     | varchar(20)         | YES  |     | NULL    |                |
| passwd   | varchar(20)         | YES  |     | NULL    |                |
| email    | varchar(50)         | YES  |     | NULL    |                |
| home     | varchar(100)        | YES  |     | NULL    |                |
| title    | varchar(255)        | YES  |     | NULL    |                |
| content  | text                | YES  |     | NULL    |                |
| reg_date | int(10) unsigned    | YES  |     | NULL    |                |
| count    | int(10) unsigned    | YES  |     | NULL    |                |
| ref      | int(10) unsigned    | YES  |     | NULL    |                |
| level    | tinyint(3) unsigned | YES  |     | NULL    |                |
| step     | tinyint(3) unsigned | YES  |     | NULL    |                |
+----------+---------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)

mysql> desc board;
+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| code     | int(10) unsigned |      | PRI | NULL    | auto_increment |
| bbs_code | varchar(20)      |      |     |         |                |
| name     | varchar(20)      |      |     |         |                |
| passwd   | varchar(20)      |      |     |         |                |
| email    | varchar(50)      |      |     |         |                |
| home     | varchar(100)     |      |     |         |                |
| title    | varchar(255)     |      |     |         |                |
| content  | text             |      |     |         |                |
| reg_date | int(10)          |      |     | 0       |                |
| count    | int(10)          |      |     | 0       |                |
| ref      | int(10)          |      |     | 0       |                |
| level    | tinyint(3)       |      |     | 0       |                |
| step     | tinyint(3)       |      |     | 0       |                |
+----------+------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)

mysql> desc board1;
+----------+-------------+------+-----+------------+----------------+
| Field    | Type        | Null | Key | Default    | Extra          |
+----------+-------------+------+-----+------------+----------------+
| num      | int(11)     |      | PRI | NULL       | auto_increment |
| name     | varchar(20) |      |     |            |                |
| email    | varchar(30) |      |     |            |                |
| hpage    | varchar(50) |      |     |            |                |
| subject  | varchar(70) | YES  |     | NULL       |                |
| content  | text        |      |     |            |                |
| dbpass   | varchar(20) |      |     |            |                |
| userip   | varchar(30) |      |     |            |                |
| reg_date | date        |      |     | 0000-00-00 |                |
| cnt      | int(11)     |      |     | 0          |                |
+----------+-------------+------+-----+------------+----------------+
10 rows in set (0.01 sec)

mysql> desc cart;
+---------------+------------------+------+-----+---------------------+-------+
| Field         | Type             | Null | Key | Default             | Extra |
+---------------+------------------+------+-----+---------------------+-------+
| product_id    | int(11)          |      |     | 0                   |       |
| product_name  | varchar(30)      |      |     |                     |       |
| product_price | int(10) unsigned |      |     | 0                   |       |
| product_count | int(10) unsigned |      |     | 0                   |       |
| added_time    | datetime         |      |     | 0000-00-00 00:00:00 |       |
| id            | varchar(30)      |      |     |                     |       |
+---------------+------------------+------+-----+---------------------+-------+
6 rows in set (0.00 sec)

mysql> desc member;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| num      | int(11)      |      | PRI | NULL    | auto_increment |
| userid   | varchar(20)  |      | UNI |         |                |
| userpass | varchar(20)  |      |     |         |                |
| question | varchar(150) |      |     |         |                |
| answer   | varchar(50)  |      |     |         |                |
| username | varchar(30)  |      |     |         |                |
| email    | varchar(50)  |      |     |         |                |
| jumin    | varchar(13)  |      |     |         |                |
| tel      | varchar(20)  |      |     |         |                |
| zip      | varchar(7)   |      |     |         |                |
| address  | varchar(50)  |      |     |         |                |
| job      | varchar(50)  |      |     |         |                |
| hobby    | varchar(50)  |      |     |         |                |
+----------+--------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)

mysql> desc memo;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| pid      | int(11)     |      |     | 0       |       |
| memoname | varchar(20) |      |     |         |       |
| memopass | varchar(30) |      |     |         |       |
| memo     | text        |      |     |         |       |
| step     | int(11)     |      |     | 0       |       |
+----------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> desc mymemo;
+-------+--------------+------+-----+---------+----------------+
| Field | Type         | Null | Key | Default | Extra          |
+-------+--------------+------+-----+---------+----------------+
| num   | int(11)      |      | PRI | NULL    | auto_increment |
| name  | varchar(20)  |      |     |         |                |
| email | varchar(30)  |      |     |         |                |
| memo  | varchar(100) |      |     |         |                |
+-------+--------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

mysql> desc product;
+----------------+------------------+------+-----+---------+----------------+
| Field          | Type             | Null | Key | Default | Extra          |
+----------------+------------------+------+-----+---------+----------------+
| product_id     | int(11)          |      | PRI | NULL    | auto_increment |
| category_large | varchar(20)      |      |     |         |                |
| category_small | varchar(20)      |      |     |         |                |
| product_name   | varchar(20)      |      |     |         |                |
| product_price  | int(10) unsigned |      |     | 0       |                |
| product_remain | int(10) unsigned |      |     | 0       |                |
| product_doc    | text             |      |     |         |                |
| product_img    | varchar(50)      |      |     |         |                |
| product_type   | varchar(20)      |      |     |         |                |
| milage         | int(11)          |      |     | 0       |                |
+----------------+------------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

mysql> desc result;
+---------------+---------------------+------+-----+---------------------+----------------+
| Field         | Type                | Null | Key | Default             | Extra          |
+---------------+---------------------+------+-----+---------------------+----------------+
| result_id     | int(10) unsigned    |      | PRI | NULL                | auto_increment |
| id            | varchar(20)         |      |     |                     |                |
| pay_time      | datetime            |      |     | 0000-00-00 00:00:00 |                |
| pay_info      | varchar(20)         |      |     |                     |                |
| pay_check     | enum(`´ë±â`,`¿Ï·á`) | YES  |     | NULL                |                |
| product_id    | int(10) unsigned    |      |     | 0                   |                |
| product_price | int(10) unsigned    |      |     | 0                   |                |
| product_count | int(10) unsigned    |      |     | 0                   |                |
| total_price   | int(10) unsigned    |      |     | 0                   |                |
| send          | enum(`´ë±â`,`¿Ï·á`) | YES  |     | NULL                |                |
| tran_addr     | varchar(50)         |      |     |                     |                |
| product_name  | varchar(20)         |      |     |                     |                |
+---------------+---------------------+------+-----+---------------------+----------------+
12 rows in set (0.00 sec)

mysql> desc zipcode1;
+---------+--------------------------+------+-----+---------+-------+
| Field   | Type                     | Null | Key | Default | Extra |
+---------+--------------------------+------+-----+---------+-------+
| NUMBER  | int(9)                   | YES  |     | NULL    |       |
| STATE   | varchar(16)              |      |     |         |       |
| CITY    | varchar(20)              |      |     |         |       |
| ADDRESS | varchar(60)              |      |     |         |       |
| ETC     | varchar(80)              |      |     |         |       |
| INCH    | varchar(80)              |      |     |         |       |
| BS      | varchar(80)              |      |     |         |       |
| BE      | varchar(80)              |      |     |         |       |
| PNF     | int(3) unsigned zerofill |      |     | 000     |       |
| PNS     | int(3) unsigned zerofill |      |     | 000     |       |
| DDD     | char(3)                  |      |     |         |       |
+---------+--------------------------+------+-----+---------+-------+
11 rows in set (0.00 sec)

mysql>
mysql>
mysql>
mysql>
mysql>