Differences
This shows you the differences between two versions of the page.
|
projs:clans:docs:dataset_db_stock_return [2014/01/20 20:51] cheungzeecn |
projs:clans:docs:dataset_db_stock_return [2014/01/21 09:15] (current) cheungzeecn |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| =====Description===== | =====Description===== | ||
| - | This table stores companys' performance by month. | + | This table stores companys' performance by month. |
| + | Abouts 239402 records（2014-01-21）. | ||
| =====Table format===== | =====Table format===== | ||
| - | +----------+------------+------+-----+---------+-------+ | + | ^ Field ^Type ^Null ^ Key ^Default ^ Extra | |
| - | | Field | Type | Null | Key | Default | Extra | | + | |
| - | +----------+------------+------+-----+---------+-------+ | + | |
| | stock_id | bigint(20) | NO | PRI | NULL | | | | stock_id | bigint(20) | NO | PRI | NULL | | | ||
| | date | double | NO | PRI | NULL | | | | date | double | NO | PRI | NULL | | | ||
| | mth_ret | double | NO | | NULL | | | | mth_ret | double | NO | | NULL | | | ||
| - | +----------+------------+------+-----+---------+———+ | ||
| =====record example===== | =====record example===== | ||
| - | +----------+--------+-----------+ | + | ^ stock_id ^date ^ mth_ret ^ |
| - | | stock_id | date | mth_ret | | + | |
| - | +----------+--------+-----------+ | + | |
| | 1 | 199201 | 0.010984 | | | 1 | 199201 | 0.010984 | | ||
| | 1 | 199202 | -0.024365 | | | 1 | 199202 | -0.024365 | | ||
| Line 21: | Line 17: | ||
| =====change log===== | =====change log===== | ||
| newly built | newly built | ||
| + | <code> | ||
| + | CREATE TABLE `stock_return` ( | ||
| + | `stock_id` bigint(20) NOT NULL, | ||
| + | `date` double NOT NULL, | ||
| + | `mth_ret` double NOT NULL, | ||
| + | PRIMARY KEY (`stock_id`,`date`) | ||
| + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | ||
| + | </code> | ||
