ㄴㅁㅇ
Tables (17)
ADMINS
- id — INT
- user_id — INT — Foreign key → USERS.id — NOT NULL
- facility_id — INT — Foreign key → FACILITIES.id
- role — VARCHAR(50) — NOT NULL
BOARDS
- id — INT
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50) — NOT NULL
CAMPUS_PLACES
- id — INT
- kakao_place_id — VARCHAR(100) — NOT NULL
- name — VARCHAR(150) — NOT NULL
- category — VARCHAR(50)
COMMENTS
- id — INT
- post_id — INT — Foreign key → POSTS.id — NOT NULL
- user_id — INT — Foreign key → USERS.id — NOT NULL
- parent_id — INT — Foreign key → COMMENTS.id
- content — TEXT — NOT NULL
- created_at — DATETIME
COURSES
- id — INT
- name — VARCHAR(100) — NOT NULL
- type — VARCHAR(50) — NOT NULL
- credit — INT — NOT NULL
DEPARTMENTS
- id — INT
- name — VARCHAR(100) — NOT NULL
ENROLLMENTS
- id — INT
- user_id — INT — Foreign key → USERS.id — NOT NULL
- course_id — INT — Foreign key → COURSES.id — NOT NULL
- grade — VARCHAR(10)
- semester — VARCHAR(20) — NOT NULL
FACILITIES
- id — INT
- name — VARCHAR(100) — NOT NULL
- location — VARCHAR(255) — NOT NULL
GRADUATION_CHECK
- id — INT
- user_id — INT — Foreign key → USERS.id — NOT NULL
- major_required_credits — INT
- liberal_required_credits — INT
- elective_credits — INT
- last_updated — DATETIME
MENTORING
- id — INT
- mentor_id — INT — Foreign key → USERS.id — NOT NULL
- mentee_id — INT — Foreign key → USERS.id — NOT NULL
- status — VARCHAR(50)
PLACE_PHOTOS
- id — INT
- place_id — INT — Foreign key → CAMPUS_PLACES.id — NOT NULL
- user_id — INT — Foreign key → USERS.id — NOT NULL
- image_url — VARCHAR(512) — NOT NULL
- uploaded_at — DATETIME
POSTS
- id — INT
- board_id — INT — Foreign key → BOARDS.id — NOT NULL
- user_id — INT — Foreign key → USERS.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
RESERVATIONS
- id — INT
- facility_id — INT — Foreign key → FACILITIES.id — NOT NULL
- user_id — INT — Foreign key → USERS.id — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- status — VARCHAR(50)
TEAM_MEMBERS
- id — INT
- project_id — INT — Foreign key → TEAM_PROJECTS.id — NOT NULL
- user_id — INT — Foreign key → USERS.id — NOT NULL
- role — VARCHAR(100)
TEAM_PROJECTS
- id — INT
- created_by — INT — Foreign key → USERS.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
USERS
- id — INT
- department_id — INT — Foreign key → DEPARTMENTS.id — NOT NULL
- student_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- created_at — DATETIME