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