Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| code | CHAR | 15 | null |
|
|
FK顧客コード Note: 多分10桁だけど余分に5桁取っている |
||||
| line_number | VARCHAR | 255 | null |
|
|
行番号 |
||||
| choice_rank | VARCHAR | 255 | null |
|
|
志望順位 |
||||
| campus_code | VARCHAR | 255 | null |
|
|
キャンパスコード |
||||
| campus_grade_code | VARCHAR | 255 | null |
|
|
学年コード |
||||
| exam_date | VARCHAR | 255 | null |
|
|
試験日付 |
||||
| exam_time | VARCHAR | 255 | null |
|
|
試験時刻 |
||||
| announcement_date | VARCHAR | 255 | null |
|
|
合格発表日付 |
||||
| announcement_time | VARCHAR | 255 | null |
|
|
合格発表時刻 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| temporary_obic_customer_choice_school_code_line_number_unique | Must be unique | Asc/Asc | code + line_number |
Relationships
Close relationships within degrees of separation
