Goal Share ERD

Tables (7)

Friend (friend)

  • Id (id) — BIGINT — Primary key — NOT NULL
  • User (friend_user_id) — BIGINT
  • IsFriendAccepted (is_friend_accepted) — TINTINT(1)
  • CreatedAt (created_at) — DATETIME
  • AcceptedAt (accepted_at) — DATETIME
  • User (user_id) — BIGINT — Foreign key → User.Id — NOT NULL

Goal (goal)

  • Id (id) — BIGINT — Primary key — NOT NULL
  • GoalName (goal_name) — VARCHAR(12)
  • GoalColor (goal_color) — VARCHAR
  • GoalAccessLevel (goal_access_level) — VARCHAR
  • GoalDeadLine (goal_dead_line) — DATETIME
  • CreatedAt (created_at) — DATETIME
  • IsDisplayedTags (is_displayed_tags) — TINYINT(1)
  • ModifiedAt (modified_at) — DATETIME
  • User (user_id) — BIGINT — Foreign key → User.Id — NOT NULL

GoalTag (goal_tag)

  • Id (id) — BIGINT — Primary key — NOT NULL
  • CreatedAt (created_at) — DATETIME
  • Tag (tag_id) — BIGINT — Foreign key → Tag.Id — NOT NULL
  • Goal (goal_id) — BIGINT — Foreign key → Goal.Id — NOT NULL

Letter (letter)

  • Id (id) — BIGINT — Primary key — NOT NULL
  • LetterContent (letter_content) — VARCHAR
  • LetterImageUrl (letter_image_url) — VARCHAR
  • CreatedAt (created_at) — DATETIME
  • ModifiedAt (modified_at) — DATETIME
  • User (user_id) — BIGINT — Foreign key → User.Id — NOT NULL
  • Goal (goal_id) — BIGINT — Foreign key → Goal.Id — NOT NULL

Like (like)

  • Id (id) — BIGINT — Primary key — NOT NULL
  • CreatedAt (created_at) — DATETIME
  • Letter (letter_id) — BIGINT — Foreign key → Letter.Id — NOT NULL
  • User (user_id) — BIGINT — Foreign key → User.Id — NOT NULL

Tag (tag)

  • Id (id) — BIGINT — Primary key — NOT NULL
  • TagName (Field) — VARCHAR

User (user)

  • Id (id) — BIGINT — Primary key — NOT NULL
  • UserName (username) — VARCHAR
  • UserStatusMessage (user_status_message) — VARCHAR
  • UserMotto (user_motto) — VARCHAR
  • UserProfileImageUrl (user_profile_image_url) — VARCHAR
  • CreatedAt (created_at) — DATETIME
  • ModifiedAt (modified_at) — DATETIME