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