ㄴㅁㅇ

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)

CHATBOT_SESSIONS

  • CREATE — TABLE

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