apk
Tables (41)
AdmissionInformation (입시 안내문)
- id — INTEGER — Foreign key → University.id — NOT NULL
- id (id2) — PK — Foreign key → University.id — NOT NULL
- id (Integer) — PK — Foreign key → University.id
ApplicationHistory (지원 이력)
- 아이디 (id) — PK — Primary key — NOT NULL
- Field
Apply (접수)
- 아이디 (id) — PK — Primary key — NOT NULL
- Field
ApplyStatus (접수 상태)
- PENDING (Field2) — Primary key
- COMPLETED (Field)
- Field3
Authorization (권한)
- 아이디 (id) — PK — Primary key — NOT NULL
- 아이디 (id2) — PK — Foreign key → User.아이디
- 권한명 (name) — VARCHAR
- 권한코드 (code) — VARCHAR
Banner (배너)
- 아이디 (id) — PK — Primary key — NOT NULL
- 파일위치 (address) — VARCHAR
- 파일명 (name) — VARCHAR
- 파일유형 (type) — VARCHAR
Bookmark (북마크)
- id (Integer) — PK — Foreign key → User.아이디
- id — INTEGER — Foreign key → University.id — NOT NULL
- id (id2) — PK — Foreign key → University.id — NOT NULL
- id (Integer2) — PK — Foreign key → University.id
Category (대학 카테고리)
- id — INTEGER — Foreign key → University.id — NOT NULL
- id (id2) — PK — Foreign key → University.id — NOT NULL
- id (Integer) — PK — Foreign key → University.id
Curriculum (커리큘럼)
- id — INTEGER — Foreign key → Department.id — NOT NULL
- id (id2) — INTEGER — Foreign key → Department.id — NOT NULL
- id (id22) — PK — Foreign key → Department.id — NOT NULL
- id (Integer) — PK — Foreign key → Department.id
Department (학과)
- id — INTEGER — Primary key — NOT NULL
- id (id2) — INTEGER — Foreign key → Category.id — NOT NULL
- id (id22) — PK — Foreign key → Category.id — NOT NULL
- id (Integer) — PK — Foreign key → Category.id
Document (원서(이력서같은 것, 공통서류))
- id — PK — Primary key — NOT NULL
DocumentStatus (원서 상태)
- id (아이디) — PK — Primary key — NOT NULL
- Field
Group (그룹)
- 아이디 (id) — PK — Foreign key → User.아이디
Mentor (멘토)
- id — PK — Primary key — NOT NULL
- id (Integer) — PK — Foreign key → User.아이디
- name — VARCHAR
- age — INTEGER
News (뉴스)
- id — PK — Primary key — NOT NULL
- Field
Photo (사진)
- 아이디 (id) — PK — Foreign key → User.아이디
Place (Untitled)
- id — PK — Primary key — NOT NULL
- longitude — INTEGER
- lattitude — INTEGER
QnA (문의)
- id — PK — Primary key — NOT NULL
- categoryId — FK — Foreign key → QnA Category.id
- title — VARCHAR
- content — TEXT
- password — VARCHAR
- type — VARCHAR
- Field
QnA Category (문의 카테고리)
- id (id) — PK — Primary key
- Field
Resource (리소스)
- Key — Primary key — NOT NULL
- id — INTEGER — Foreign key → University.id — NOT NULL
- id (id2) — PK — Foreign key → University.id — NOT NULL
- id (Integer) — PK — Foreign key → University.id
Role (유형)
- 아이디 (id) — PK — Primary key — NOT NULL
- 아이디 (id2) — PK — Foreign key → User.아이디
- 역할명 (name) — VARCHAR
- 역할코드 (code) — VARCHAR
Tip (팁)
- id — PK — Primary key — NOT NULL
- Field
University (대학교)
- id — INTEGER — Primary key — NOT NULL
- id (id2) — PK — Foreign key → Mentor.id — NOT NULL
- id (Integer) — PK — Foreign key → Mentor.id
User (회원)
- 아이디 (id) — PK — Primary key
- 이름 (username) — VARCHAR
- 비밀번호 (password) — VARCHAR
- 닉네임 (nickname) — VARCHAR
- 이메일 (email) — VARCHAR, UNIQUE
- Field
대학원 (Untitled5)
- id — INTEGER — Foreign key → University.id — NOT NULL
- id (id2) — PK — Foreign key → University.id — NOT NULL
- id (Integer) — PK — Foreign key → University.id
신입학 (Untitled3)
- id — INTEGER — Foreign key → University.id — NOT NULL
- id (id2) — PK — Foreign key → University.id — NOT NULL
- id (Integer) — PK — Foreign key → University.id
어학원 (Untitled2)
- id — INTEGER — Foreign key → University.id — NOT NULL
- id (id2) — PK — Foreign key → University.id — NOT NULL
- id (Integer) — PK — Foreign key → University.id
편입학 (Untitled4)
- id — INTEGER — Foreign key → University.id — NOT NULL
- id (id2) — PK — Foreign key → University.id — NOT NULL
- id (Integer) — PK — Foreign key → University.id