制約 | 参照用テーブル | 外部キー | 参照されるテーブル | 主キー |
1 | BILLING | Registrar_ID | PERSON | ID |
2 | STUDENT | ID | PERSON | ID |
3 | FACULTY | ID | PERSON | ID |
4 | STUDENT | Tuition_ID | TUITION | ID |
5 | FACULTY | Building_Name、Room_Number | ROOM | Building_Name、Number |
6 | DEPARTMENT | Building_Name、Room_Number | ROOM | Building_Name、Number |
7 | CLASS | Building_Name、Room_Number | ROOM | Building_Name、Number |
8 | FACULTY | Dept_Name | DEPARTMENT | Name |
9 | DEPARTMENT | Head_Of_Dept | FACULTY | ID |
10 | STUDENT | Major | DEPARTMENT | Name |
11 | STUDENT | Minor | DEPARTMENT | Name |
12 | COURSE | Dept_Name | DEPARTMENT | Name |
13 | BILLING | Student_ID | STUDENT | ID |
14 | ENROLLS | Student_ID | STUDENT | ID |
15 | CLASS | Faculty_ID | FACULTY | ID |
16 | CLASS | Course_Name | COURSE | Name |
17 | ENROLLS | Class_ID | CLASS | ID |
列 | データ型 | サイズ | キー |
Student_ID | UBIGINT | 8 | 主キー、外部キー |
Transaction_Number | USMALLINT | 2 | 主キー |
Log | TIMESTAMP | 8 | |
Amount_Owed | DECIMAL | 7.2 | |
Amount_Paid | DECIMAL | 7.2 | |
Registrar_ID | UBIGINT | 8 | 外部キー |
Comments | LONGVARCHAR | 65500 |
列 | データ型 | サイズ | キー |
ID | IDENTITY | 4 | 主キー |
Name | CHARACTER | 7 | 外部キー |
Section | CHARACTER | 3 | |
Max_Size | USMALLINT | 2 | |
Start_Date | DATE | 4 | |
Start_Time | TIME | 4 | |
Finish_Time | TIME | 4 | |
Building_Name | CHARACTER | 25 | 外部キー |
Room_Number | UINTEGER | 4 | 外部キー |
Faculty_ID | UBIGINT | 8 | 外部キー |
列 | データ型 | サイズ | キー |
Name | CHARACTER | 7 | 主キー |
Description | CHARACTER | 50 | |
Credit_Hours | USMALLINT | 2 | |
Dept_Name | CHARACTER | 20 | 外部キー |
列 | データ型 | サイズ | キー |
Name | CHARACTER | 20 | 主キー |
Phone_Number | DECIMAL | 10.0 | |
Building_Name | CHARACTER | 25 | 外部キー |
Room_Number | UINTEGER | 4 | 外部キー |
Head_of_Dept | UBIGINT | 8 | 外部キー |
列 | データ型 | サイズ | キー |
Student_ID | UBIGINT | 8 | 主キー、外部キー |
Class_ID | INTEGER | 4 | 主キー、外部キー |
Grade | REAL | 4 |
列 | データ型 | サイズ | キー |
ID | UBIGINT | 8 | 主キー、外部キー |
Dept_Name | CHARACTER | 20 | 外部キー |
Designation | CHARACTER | 10 | |
Salary | CURRENCY | 8 | |
Building_Name | CHARACTER | 25 | 外部キー |
Room_Number | UINTEGER | 4 | 外部キー |
Rsch_Grant_Money | FLOAT | 8 |
列 | データ型 | サイズ | キー |
ID | UBIGINT | 8 | 主キー |
First_Name | VARCHAR | 15 | |
Last_Name | VARCHAR | 25 | |
Perm_Street | VARCHAR | 30 | |
Perm_City | VARCHAR | 30 | |
Perm_State | VARCHAR | 2 | |
Perm_Zip | VARCHAR | 10 | |
Perm_Country | VARCHAR | 20 | |
Street | VARCHAR | 30 | |
City | VARCHAR | 30 | |
State | VARCHAR | 2 | |
Zip | VARCHAR | 10 | |
Phone | DECIMAL | 10.0 | |
Emergency_Phone | CHARACTER | 20 | |
Unlisted | BIT | 1 | |
Date_Of_Birth | DATE | 4 | |
Email_Address | VARCHAR | 30 | |
Sex | BIT | 1 | |
Citizenship | VARCHAR | 20 | |
Survey | BIT | 1 | |
Smoker | BIT | 1 | |
Married | BIT | 1 | |
Children | BIT | 1 | |
Disability | BIT | 1 | |
Scholarship | BIT | 1 | |
Comments | LONGVARCHAR | 65500 |
列 | データ型 | サイズ | キー |
Building_Name | CHARACTER | 25 | 主キー |
Number | UINTEGER | 4 | 主キー |
Capacity | USMALLINT | 2 | |
Type | CHARACTER | 20 |
列 | データ型 | サイズ | キー |
ID | UBIGINT | 8 | 主キー、外部キー |
Cumulative_GPA | DECIMAL | 5.3 | |
Tuition_ID | INTEGER | 4 | 外部キー |
Transfer_Credits | DECIMAL | 4.0 | |
Major | CHARACTER | 20 | 外部キー |
Minor | CHARACTER | 20 | 外部キー |
Scholarship_Money | DECIMAL | 19.2 | |
Cumulative_Hours | SMALLINT | 2 |
列 | データ型 | サイズ | キー |
ID | INTEGER | 4 | 主キー |
Degree | VARCHAR | 4 | |
Residency | BIT | 1 | |
Cost_Per_Credit | REAL | 4 | |
Comments | LONGVARCHAR | 65500 |