Esta ERD

Tables (10)

Chatroom (chatrooms)

  • chatroom_id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → User.user_id — NOT NULL
  • user_id (FK2) — bigint — Foreign key → User.user_id — NOT NULL
  • created_at (Field) — timestamp
  • content (Field2) — varchar(200)

Hashtag (hashtags)

  • Tag_id (PK) — bigint — Primary key — NOT NULL
  • name (Field) — varch(50)

Like (likes)

  • story_comment_id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → User.user_id — NOT NULL
  • story_id (FK2) — bigint — Foreign key → Story.story_id — NOT NULL
  • liked (Field) — boolean

Story (stories)

  • story_id (PK) — bigint — Primary key — NOT NULL
  • author (FK) — bigint — Foreign key → User.user_id — NOT NULL
  • Tag_id (FK2) — bigint — Foreign key → Hashtag.Tag_id — NOT NULL
  • likes (FK3) — bigint — Foreign key → User.user_id — NOT NULL
  • title (Field) — varchar(30)
  • content (Field2) — varchar(400)
  • like (Field3) — bigint
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp
  • views (Field7) — bigint

Story_PostImage

  • postimage_id (PK) — bigint — Primary key — NOT NULL
  • story_id (FK) — bigint — Foreign key → Story.story_id — NOT NULL
  • images (Field) — ImageField

Story_comment (Story_comments)

  • story_comment_id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → User.user_id — NOT NULL
  • story_id (FK2) — bigint — Foreign key → Story.story_id — NOT NULL
  • content (Field) — varchar(100)
  • created_at (Field2) — timestamp
  • updated_at (Field3) — timestamp
  • parents_id (FK3) — bigint — Foreign key → Story_comment.story_comment_id — NOT NULL

Study (studies)

  • study_id (PK) — bigint — Primary key — NOT NULL
  • party_id (FK) — bigint — Foreign key → Team.party_id — NOT NULL
  • user_id (FK2) — bigint — Foreign key → Team.user_id — NOT NULL
  • study_title (Field) — varchar(100)
  • study_content (Field2) — varchar(300)
  • study_tag (Field3) — varchar(30)
  • created_at (Field4) — timestamp
  • end_date (Field5) — timestamp

Study_comment (study_comments)

  • study_comments_id (PK) — bigint — Primary key — NOT NULL
  • study_id (FK) — bigint — Foreign key → Study.study_id — NOT NULL
  • content (Field) — varchar(50)

Team (teams)

  • party_id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → User.user_id — NOT NULL
  • user_id (FK2) — bigint — Foreign key → User.user_id — NOT NULL
  • content (Field) — varchar(300)

User (users)

  • user_id (PK) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • e-mail (Field2) — varchar(50)
  • password (Field3) — varchar(20)
  • nickname (Field4) — varchar(40)
  • profile (Field5) — varchar(200)
  • kdt (Field6) — varchar(50)
  • when (Field7) — bigint