Estagram ERD
Tables (15)
Alarm (alarm)
- alarm_id (PK) — bigint — Primary key — NOT NULL
- study_id (FK) — bigint — Foreign key → Study.study_id — NOT NULL
- story_post_id (FK2) — bigint — Foreign key → Story_Post.story_post_id — NOT NULL
- user_id (FK3) — bigint — Foreign key → User.user_id — NOT NULL
- content (Field) — varchar(255)
- is_check (Field2) — boolean
- created_at (Field3) — timestamp
Chat_Message (chat_message)
- chat_message_id (PK) — bigint — Primary key — NOT NULL
- chat_room_id (FK) — bigint — Foreign key → Chat_Room.chat_room_id — NOT NULL
- sender (Field) — varchar(255)
- receiver (Field2) — varchar(255)
- content (Field3) — textfield
- send_at (Field4) — timestamp
- is_read (Field5) — boolean
Chat_Room (chat_room)
- chat_room_id (PK) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.user_id — NOT NULL
- chat_host (Field) — varchar(255)
- chat_guest (Field2) — varchar(255)
Story_Comments (story_comments)
- story_comments_id (PK) — bigint — Primary key — NOT NULL
- story_post_id (FK) — bigint — Foreign key → Story_Post.story_post_id — NOT NULL
- content (Field) — varchar(100)
- created_at (Field2) — timestamp
Story_Hashtag (story_hashtag)
- story_hashtag_id (PK) — bigint — Primary key — NOT NULL
- story_post_id (FK) — bigint — Foreign key → Story_Post.story_post_id — NOT NULL
- name (Field) — varchar(500)
Story_Like (story_like)
- story_like_id (PK) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.user_id — NOT NULL
- story_post_id (FK2) — bigint — Foreign key → Story_Post.story_post_id — NOT NULL
- liked (Field) — boolean
Story_Post (story_post)
- story_post_id (PK) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.user_id — NOT NULL
- story_hashtag_id (FK2) — bigint — Foreign key → Story_Hashtag.story_hashtag_id — NOT NULL
- story_post_id (FK3) — bigint — Foreign key → Story_Hashtag.story_post_id — NOT NULL
- title (Field) — varchar(200)
- content (Field2) — varchar(200)
- views (Field3) — bigint
- created_at (Field4) — timestamp
- updated_at (Field5) — timestamp
- like (Field6) — manytomany
- is_public (Field8) — boolean
Story_PostImage (story_postimage)
- story_postimage_id (PK) — bigint — Primary key — NOT NULL
- story_post_id (FK) — bigint — Foreign key → Story_Post.story_post_id — NOT NULL
- images (Field) — varchar(100)
Study (study)
- study_id (PK) — bigint — Primary key — NOT NULL
- user_id (FK2) — bigint — Foreign key → User.user_id — NOT NULL
- title (Field2) — varchar(100)
- content (Field3) — varchar(300)
- created_at (Field4) — timestamp
- end_at (Field5) — timestamp
- start_at (Field6) — timestamp
- views (Field7) — bigint
- project_study (Field8) — varchar(8)
- online_offline (Field9) — varchar(5)
- field (Field10) — varchar(10)
- stacks (Field11) — manytomany
- participant_count (Field12) — varchar(10)
- period (Field13) — varchar(10)
- public_private (Field14) — boolean
Study_Comment (study_comment)
- study_comment_id (PK) — bigint — Primary key — NOT NULL
- study_id (FK) — bigint — Foreign key → Study.study_id — NOT NULL
- content (Field) — varchar(100)
- created_at (Field2) — timestamp
Study_Like (study_like)
- study_like_id (PK) — bigint — Primary key — NOT NULL
- study_id (FK) — bigint — Foreign key → Study.study_id — NOT NULL
- user_id (FK2) — bigint — Foreign key → User.user_id — NOT NULL
- liked (Field) — boolean
Study_Stacks (study_stacks)
- study_stack_id (PK) — bigint — Primary key — NOT NULL
- study_id (FK) — bigint — Foreign key → Study.study_id — NOT NULL
- user_id (FK3) — bigint — Foreign key → Study.user_id — NOT NULL
- name (Field) — varchar(12)
Study_Team (study_team)
- study_team_id (PK) — bigint — Primary key — NOT NULL
- study_id (FK) — bigint — Foreign key → Study.study_id — NOT NULL
- user_id (FK2) — bigint — Foreign key → User.user_id — NOT NULL
- name (Field) — varchar(100)
- description (Field2) — textfeild
- members (Field3) — manytomany
- aplications (Field4) — manytomany
Study_Teammember (study_teammember)
- study_teammember_id (Key) — bigint — Primary key — NOT NULL
- study_team_id (FK) — bigint — Foreign key → Study_Team.study_team_id — NOT NULL
- user_id (FK2) — bigint — Foreign key → Study_Team.user_id — NOT NULL
- is_approved (Field) — boolean
User (user)
- user_id (PK) — bigint — Primary key — NOT NULL
- email (Field) — EmailField
- username (Field2) — varchar(50)
- password (Field3) — varchar(255)
- nickname (Field4) — varchar(255)
- bootcamp (Field5) — varchar(255)
- profile_img (Field6) — FileField
- info (Field7) — TextField
- created_at (Field8) — timestamp