sesacc
Tables (22)
ActivityParticipant
- id — integer — NOT NULL
- activity_report_id — integer — Foreign key → ActivityReport.id
- user_id — integer — Foreign key → User.id
ActivityReport
- id — integer — NOT NULL
- group_post_id — integer — Foreign key → GroupPost.id
- activity_date — date — NOT NULL
- activity_duration — integer
- main_content — varchar(100)
- achievement_summary — varchar(20)
- photo — varchar(255)
Campus
- id — integer — NOT NULL
- name — varchar(255) — NOT NULL
CampusChangeRequest
- id — integer — NOT NULL
- user_id — integer — Foreign key → User.id
- new_campus_id — integer — Foreign key → Campus.id
- new_course_id — integer — Foreign key → Course.id
- status — enum
- created_at — timestamp
- updated_at — timestamp
Comment
- id — integer — NOT NULL
- user_id — integer — Foreign key → User.id
- post_id — integer — Foreign key → Post.id
- content — text — NOT NULL
- created_at — timestamp
- updated_at — timestamp
Course
- id — integer — NOT NULL
- name — varchar(255) — NOT NULL
- campus_id — integer — Foreign key → Campus.id
Follow
- id — integer — NOT NULL
- follower_id — integer — Foreign key → User.id
- following_id — integer — Foreign key → User.id
- created_at — timestamp
Group
- id — integer — NOT NULL
- name — varchar(255) — NOT NULL
- type — enum — NOT NULL
- course_id — integer — Foreign key → Course.id
GroupChat
- id — integer — NOT NULL
- group_id — integer — Foreign key → Group.id
- user_id — integer — Foreign key → User.id
- content — text(50) — NOT NULL
- created_at — timestamp
GroupMember
- id — integer — NOT NULL
- group_id — integer — Foreign key → Group.id
- user_id — integer — Foreign key → User.id
- role — enum
- status — enum
GroupPost
- id — integer — NOT NULL
- group_id — integer — Foreign key → Group.id
- user_id — integer — Foreign key → User.id
- type — enum — NOT NULL
- title — varchar(255) — NOT NULL
- content — text
- created_at — timestamp
- updated_at — timestamp
Hashtag
- id — integer — NOT NULL
- name — varchar(255) — NOT NULL
Like
- id — integer — NOT NULL
- user_id — integer — Foreign key → User.id
- post_id — integer — Foreign key → Post.id
- created_at — timestamp
LoginAttempt
- id — integer — NOT NULL
- user_id — integer — Foreign key → User.id
- attempt_time — timestamp
- success — boolean
Menu
- id — integer — NOT NULL
- restaurant_id — integer — Foreign key → Restaurant.id
- name — varchar(255) — NOT NULL
- price — decimal
Message
- id — integer — NOT NULL
- sender_id — integer — Foreign key → User.id
- receiver_id — integer — Foreign key → User.id
- content — text — NOT NULL
- read — boolean
- created_at — timestamp
Notification
- id — integer — NOT NULL
- user_id — integer — Foreign key → User.id
- sender_id — integer — Foreign key → User.id
- type — enum — NOT NULL
- post_id — integer — Foreign key → Post.id
- read — boolean
- created_at — timestamp
PasswordReset
- id — integer — NOT NULL
- user_id — integer — Foreign key → User.id
- token — varchar(255) — NOT NULL
- expires_at — timestamp
Post
- id — integer — NOT NULL
- user_id — integer — Foreign key → User.id
- title — varchar(20) — NOT NULL
- content — text
- image — varchar(255)
- thumbnail — varchar(255)
- likes_count — integer
- comments_count — integer
- is_notice — boolean
- created_at — timestamp
- updated_at — timestamp
PostHashtag
- id — integer — NOT NULL
- post_id — integer — Foreign key → Post.id
- hashtag_id — integer — Foreign key → Hashtag.id
Restaurant
- id — integer — NOT NULL
- name — varchar(255) — NOT NULL
- address — text
- category — varchar(255)
- course_id — integer — Foreign key → Course.id
User
- id — integer — NOT NULL
- name — varchar(255) — NOT NULL
- birth_date — date
- gender — char(1)
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- nickname — varchar(10)
- profile_image — varchar(255)
- campus_id — integer — Foreign key → Campus.id
- course_id — integer — Foreign key → Course.id
- status — enum
- is_manager — boolean
- created_at — timestamp
- updated_at — timestamp