sidefit
Tables (13)
bookmark
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → user.id — NOT NULL
- post_id — bigint(20) — Foreign key → post.id — NOT NULL
category
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- created_date — VARCHAR(255)
- last_modified_date — VARCHAR(255)
chat
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → user.id — NOT NULL
- chatroom_id — bigint(20) — Foreign key → chatroom.id — NOT NULL
- message — varchar(500)
- created_date — timestamp — NOT NULL
- last_modified_date — timestamp — NOT NULL
chatroom
- id — bigint(20) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- created_date — timestamp — NOT NULL
- last_modified_date — timestamp — NOT NULL
comment
- id — bigint(20) — Primary key — NOT NULL
- post_id — bigint(20) — Foreign key → post.id — NOT NULL
- created_date — timestamp — NOT NULL
- last_modified_date — timestamp — NOT NULL
evaluation_items
- id — NOT — Primary key — NOT NULL
- score — VARCHAR(255)
- text — VARCHAR(255)
member
- user_id — bigint(20) — Foreign key → user.id — NOT NULL
- chatroom_id — bigint(20) — Foreign key → chatroom.id — NOT NULL
notification
- id — bigint(20) — Primary key — NOT NULL
- receiver_id — bigint(20) — Foreign key → user.id — NOT NULL
- message — varchar(255) — NOT NULL
- notification_type — enum — NOT NULL
- read_or_not — boolean — NOT NULL
- created_date — timestamp — NOT NULL
post
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → user.id — NOT NULL
- team_id — bigint(20) — Foreign key → team.id — NOT NULL
- title — varchar(1000) — NOT NULL
- content — varchar(2000) — NOT NULL
- dtype — VARCHAR(255)
- created_date — timestamp — NOT NULL
- last_modified_date — timestamp — NOT NULL
review
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → user.id — NOT NULL
- writer_id — bigint(20) — Foreign key → user.id — NOT NULL
- evaluation_items — VARCHAR(255)
- content — VARCHAR(255)
- created_date — timestamp — NOT NULL
- last_modified_date — timestamp — NOT NULL — NOT NULL
team
- id — bigint(20) — Primary key — NOT NULL
- title — varchar(1000) — NOT NULL
- content — varchar(2000) — NOT NULL
- status — enum — NOT NULL
- created_date — timestamp — NOT NULL
- last_modified_date — timestamp — NOT NULL
user
- id — bigint(20) — Primary key — NOT NULL
- email — varchar(100) — NOT NULL
- pw — varchar(50) — NOT NULL
- name — varchar(10) — NOT NULL
- profile_img_url — varchar(255)
- address — VARCHAR(255)
- comment — varchar(255)
- score — double — NOT NULL
- nickname — varchar(10)
- job — VARCHAR(255)
- field — enum
- stack — enum
- role — enum — NOT NULL
- created_date — timestamp — NOT NULL
- last_modified_date — timestamp — NOT NULL
user_team
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → user.id — NOT NULL
- team_id — bigint(20) — Foreign key → team.id — NOT NULL