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