moim

Tables (11)

category

  • category_id — int — Primary key — NOT NULL
  • category_title — varchar(50)

comment

  • comment_id — int — Primary key — NOT NULL
  • score — int
  • content — varchar(255)
  • created_at — datetime
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • meeting_id — int — Foreign key → meeting.meeting_id — NOT NULL

contact

  • contact_id — int — Primary key — NOT NULL
  • phone — varchar(50)
  • kakao — varchar(50)
  • github — varchar(50)
  • blog — varchar(50)
  • user_id — int — Foreign key → user.user_id — NOT NULL

likes

  • likes_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • meeting_id — int — Foreign key → meeting.meeting_id — NOT NULL

meeting

  • meeting_id — int — Primary key — NOT NULL
  • meeting_title — varchar(50)
  • created_at — datetime
  • meeting_pic — varchar(255)
  • content — TEXT
  • location — varchar(50)
  • max_member — int
  • start_date — datetime
  • public — boolean
  • enroll — boolean
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • category_id — int — Foreign key → category.category_id — NOT NULL

meeting_skill

  • meeting_skill_id — int — Primary key — NOT NULL
  • meeting_id — int — Foreign key → meeting.meeting_id — NOT NULL
  • skill_id — int — Foreign key → skill.skill_id — NOT NULL

member

  • member_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • meeting_id — int — Foreign key → meeting.meeting_id — NOT NULL
  • status — varchar(50)
  • message — varchar(255)

refresh token

  • token_id — int — Primary key — NOT NULL
  • expiry_date — Datetime
  • token — varchar(100)
  • user_id — int — Foreign key → user.user_id — NOT NULL

skill

  • skill_id — int — Primary key — NOT NULL
  • skill_title — varchar(50)

user

  • user_id — int — Primary key — NOT NULL
  • name — varchar(50)
  • email — varchar(50)
  • position — varchar(20)
  • password — varchar(255)
  • profile_pic — varchar(255)
  • intro — varchar(255)
  • gender — varchar(10)
  • location — varchar(50)
  • age — varchar(20)

user_skill

  • user_skill_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • skill_id — int — Foreign key → skill.skill_id — NOT NULL