Pchedule
Tables (11)
. (user)
- user_id — INT PK AI — Primary key
- email — VARCHAR(255) NN UNIQUE
- password — VARCHAR(255) NN 해싱
- name — VARCHAR(20) NN UNIQUE
- profile_image — VARCHAR(255) 이미지 URL 저장 NN
- Field (allow_notification) — BOOLEAN(DEFAULT=TRUE) NN
- created_at — TIMESTAMP NN
- updated_at — TIMESTAMP NN
- last_login — TIMESTAMP
- is_admin — BOOLEAN(DEFAULT=FALSE) NN
- Field (is_locked) — BOOLEAN(DEFAULT=FALSE) NN
- Field (is_reported) — BOOLEAN(DEFAULT=FALSE) NN
. (post)
- post_id — INT PK AI — Primary key — NOT NULL
- user_id — FK — Foreign key → ..user_id
- Field (title) — VARCHAR(50)
- Field2 (start_period) — DATETIME
- Field3 (end_period) — DATETIME
- Field4 (category) — VARCHAR(20) NN
- Field (priority) — ENUM(DEFAULT=MEDIUM) NN
- Field2 (share_type) — VARCHAR(20) NN
- Field (is_recurrence) — BOOLEAN(DEFAULT=FALSE) NN
- Field (is_reported) — BOOLEAN(DEFAULT=FALSE) NN
- Field (created_at) — TIMESTAMP NN
- Field2 (updated_at) — TIMESTAMP NN
LoginAttempt (login_attempt)
- attempt_id (login_attempt_id) — INT PK AI — Primary key — NOT NULL
- user_id — FK — Foreign key → ..user_id
- attempt_time (login_attempt_time) — TIMESTAMP NN
- is_success — BOOLEAN NN
- ip_address — VARCHAR(45) NN
SocialAccount (notification)
- Key (notification_id) — INT PK AI — Primary key — NOT NULL
- user_id — FK — Foreign key → ..user_id
- Field (type) — VARCHAR(20) NN
- Field2 (content) — VARCHAR(50) NN
- Field3 (is_read) — BOOLEAN(DEAFULT=FALSE) NN
- Field (is_deleted) — BOOLEAN(DEFAULT=FALSE) NN
- Field (created_at) — TIMESTAMP NN
Token (token)
- token_id — INT PK AI — Primary key — NOT NULL
- user_id — FK — Foreign key → ..user_id
- refresh_token — VARCHAR(255) NN 해싱
- created_at — TIMESTAMP NN
- expires_at — TIMESTAMP NN 만료시각
- revoked (is_revoked) — BOOLEAN(DEFAULT=FALSE) NN
Untitled (like)
- Key (like_id) — INT PK AI — Primary key — NOT NULL
- user_id — FK — Foreign key → ..user_id
- post_id — FK — Foreign key → ..post_id — NOT NULL
Untitled (report)
- Key (report_id) — INT PK AI — Primary key — NOT NULL
- user_id (reporter_user_id) — FK — Foreign key → ..user_id
- post_id — FK — Foreign key → ..post_id — NOT NULL
- Field (reason) — VARCHAR(50) NN
- Field (created_at) — TIMESTAMP NN
Untitled (favorite)
- Key (favorite_id) — INT PK AI — Primary key — NOT NULL
- user_id — FK — Foreign key → ..user_id
- post_id — FK — Foreign key → ..post_id — NOT NULL
Untitled (recurrence)
- Key (recurrence_id) — INT PK AI — Primary key — NOT NULL
- post_id — FK — Foreign key → ..post_id — NOT NULL
- Field (type) — ENUM
- Field2 (day_of_week) — ENUM
- Field3 (day_of_month) — TINYINT
- Field (month_of_year) — TINYINT
- Field (time) — TIME
Untitled (access_token_blacklist)
- Key (blacklist_id) — INT PK AI — Primary key — NOT NULL
- user_id — FK — Foreign key → ..user_id
- Field (access_token) — VARCHAR(1024) NN
- Field2 (revoked_at) — TIMESTAMP NN
Untitled2 (schedule)
- Key (schedule_id) — INT PK AI — Primary key — NOT NULL
- post_id — FK — Foreign key → ..post_id — NOT NULL
- Field3 (title) — VARCHAR(50)
- Field (description) — VARCHAR(100)
- Field (start_time) — DATETIME
- Field2 (end_time) — DATETIME
- Field (alert_minute) — INT NN
- Field (is_completed) — BOOLEAN NN
- Field2 (completed_at) — TIMESTAMP
- Field (created_at) — TIMESTAMP NN
- Field (updated_at) — TIMESTAMP NN