| SchemaSpy Analysis of sample - Columns | Generated by SchemaSpy |
| Generated by SchemaSpy on Mon Nov 06 09:05 UTC 2017 |
| ||||||
|
| |||||||
sample contains 20 columns - click on heading to sort:
| Table | Column | Type | Size | Nulls | Auto | Default | Comments |
|---|---|---|---|---|---|---|---|
| book | author | varchar | 40 | 著者 | |||
| schema_version | checksum | int | 10 | √ | null | ||
| demo_msa | demo_id | int | 10 | ||||
| schema_version | description | varchar | 200 | ||||
| schema_version | execution_time | int | 10 | ||||
| schema_version | installed_by | varchar | 100 | ||||
| schema_version | installed_on | timestamp | 19 | CURRENT_TIMESTAMP | |||
| schema_version | installed_rank | int | 10 | ||||
| book | isbn | bigint | 19 | ISBN | |||
| demo_msa | name | varchar | 100 | ||||
| person | name | varchar | 100 | ||||
| publisher | name | varchar | 40 | 出版社名 | |||
| person | person_id | int | 10 | ||||
| book | publisherid | int unsigned | 10 | 出版社ID | |||
| publisher | publisherid | int unsigned | 10 | 出版社ID | |||
| schema_version | script | varchar | 1000 | ||||
| schema_version | success | bit | 0 | ||||
| book | title | varchar | 128 | タイトル | |||
| schema_version | type | varchar | 20 | ||||
| schema_version | version | varchar | 50 | √ | null |