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

Comment (댓글)

    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.아이디

    Language (언어)

      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

      Notification (알림)

        Payment (결제)

          PaymentHistory (결제 이력)

            Photo (사진)

            • 아이디 (id) — PK — Foreign key → User.아이디

            Place (Untitled)

            • id — PK — Primary key — NOT NULL
            • longitude — INTEGER
            • lattitude — INTEGER

            Point (적립금)

              PointHistory (적립금 내역)

                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

                RankingBoard (랭킹 보드)

                  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

                  Review (리뷰)

                    Role (유형)

                    • 아이디 (id) — PK — Primary key — NOT NULL
                    • 아이디 (id2) — PK — Foreign key → User.아이디
                    • 역할명 (name) — VARCHAR
                    • 역할코드 (code) — VARCHAR

                    Story (스토리)

                      Ticket (티켓)

                        TicketHistory (티켓 내역)

                          Tip (팁)

                          • id — PK — Primary key — NOT NULL
                          • Field

                          Token (토큰)

                            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