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