scholarzip_TF
Tables (6)
Region
- id — INT — Primary key
- major_name — VARCHAR(255) — NOT NULL — 대분류
- minor_name — VARCHAR(255) — 소분류
- parent_id — INT — Foreign key → Region.id — 상위주소(참조)
- level — TINYINT — NOT NULL — 1(대분류), 2(소분류)
Scholarship
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- organization — VARCHAR(255) — NOT NULL
- income_level — TINYINT — NOT NULL — 조건3
- type — ENUM('등록금', '생활비 - 타 장학 중복 O', '생활비 - 타 장학 중복 X', '이자지원') — NOT NULL — 조건4
- application_start_date — DATE
- application_end_date — DATE — NOT NULL
- description — TEXT — NOT NULL — 장학금액
- note — TEXT — 비고
Scholarship_Region
- scholarship_id — INT — Foreign key → Scholarship.id — NOT NULL — 조건2
- region_id — INT — Foreign key → Region.id — 조건2
Scholarship_University
- scholarship_id — INT — Foreign key → Scholarship.id — NOT NULL — 조건1
- university_id — INT — Foreign key → University.id — 조건1
University
- id — INT — Primary key
- name — VARCHAR(255) — NOT NULL
User
- id — UUID — Primary key — NOT NULL
- university_id — UUID — Foreign key → University.id — NOT NULL — 조건1
- region_id — UUID — Foreign key → Region.id — NOT NULL — 조건2
- income_level — TINYINT — NOT NULL — 조건3
- has_living_expense_scholarship — BOOLEAN — NOT NULL — 조건4
- has_full_tuition_scholarship — BOOLEAN — NOT NULL — 조건4
- phone — VARCHAR(15) — NOT NULL
- createdAt — LocalDateTime — NOT NULL