Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
pref_id | INT | 10 | null |
|
|
都道府県ID |
||||
pref_name | VARCHAR | 255 | null |
|
|
都道府県名 |
||||
school_code | VARCHAR | 255 | null |
|
|
学校コード |
||||
campus_code | VARCHAR | 255 | null |
|
|
キャンパスコード |
||||
school_name | VARCHAR | 255 | null |
|
|
学校名 |
||||
campus_name | VARCHAR | 255 | null |
|
|
キャンパス名 |
||||
created_at | TIMESTAMP | 26 | √ | null |
|
|
||||
updated_at | TIMESTAMP | 26 | √ | null |
|
|
||||
deleted_at | TIMESTAMP | 26 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
unique_campus | Must be unique | Asc/Asc | school_code + campus_code |