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