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