HYCMU

Tables (20)

board

  • id — INT — Primary key — NOT NULL
  • campus — ENUM('seoul', 'cheonan')
  • site — VARCHAR(255)
  • name — VARCHAR(255) — NOT NULL
  • url — TEXT

board_subscription

  • user_id — INT — Primary key — NOT NULL
  • board_id — INT — Primary key — NOT NULL
  • notification_channel — ENUM('PUSH', 'IN_APP', 'NONE')
  • created_at — DATETIME

bookmark

  • id — INT — Primary key — NOT NULL
  • bookmark_folder_id — INT — NOT NULL
  • post_id — INT — NOT NULL

bookmark_folder

  • id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • created_at — DATETIME

cafeteria

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • location — VARCHAR(255)
  • operating_hours — VARCHAR(255)

college

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(30) — NOT NULL

department

  • id — INT — Primary key — NOT NULL
  • college_id — INT — NOT NULL
  • name — VARCHAR(30) — NOT NULL

event_schedule

  • id — INT — Primary key — NOT NULL
  • post_id — INT — NOT NULL
  • location — VARCHAR(100)
  • start_datetime — DATETIME
  • end_datetime — DATETIME
  • created_at — DATETIME

menu

  • id — INT — Primary key — NOT NULL
  • cafeteria_id — INT — NOT NULL
  • served_date — DATE — NOT NULL
  • meal_time — ENUM('BREAKFAST', 'LUNCH', 'DINNER') — NOT NULL
  • description — TEXT — NOT NULL
  • price — INT
  • image_url — VARCHAR(512)

post

  • id — INT — Primary key — NOT NULL
  • board_id — INT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content_summary — TEXT
  • view_count — INT
  • url — TEXT — NOT NULL
  • posted_date — DATETIME
  • deadline_date — DATETIME
  • importance_level — ENUM('NORMAL', 'IMPORTANT', 'CRITICAL')
  • scraped_at — DATETIME

post_attachment

  • id — INT — Primary key — NOT NULL
  • post_id — INT — NOT NULL
  • file_name — VARCHAR(255)
  • url — TEXT — NOT NULL
  • created_at — DATETIME

post_tag

  • post_id — INT — Primary key — NOT NULL
  • tag_id — INT — Primary key — NOT NULL

review

  • id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • menu_id — INT — NOT NULL
  • rating — INT — NOT NULL
  • comment — TEXT
  • created_at — DATETIME

social_account

  • id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • provider — ENUM('GOOGLE', 'KAKAO', 'NAVER') — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL

tag

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL

tag_subscription

  • user_id — INT — Primary key — NOT NULL
  • tag_id — INT — Primary key — NOT NULL
  • notification_channel — ENUM('PUSH', 'IN_APP', 'NONE')
  • created_at — DATETIME

user

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • academic_year — INT
  • student_status — ENUM('ENROLLED', 'LEAVE_OF_ABSENCE', 'GRADUATED')
  • created_at — DATETIME

user_department

  • user_id — INT — Primary key — NOT NULL
  • department_id — INT — Primary key — NOT NULL

user_post_interaction

  • user_id — INT — Primary key — NOT NULL
  • post_id — INT — Primary key — NOT NULL
  • is_read — BOOLEAN
  • is_hidden — BOOLEAN
  • reminder_at — DATETIME

user_tag

  • user_id — INT — Primary key — NOT NULL
  • tag_id — INT — Primary key — NOT NULL