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