MOYO
Tables (16)
BookMark
- post_no (Key) — bigint — Foreign key → Post.no — NOT NULL
- user_no (Key2) — bigint — Foreign key → User.no — NOT NULL
Comment
- no (Key3) — bigint — Primary key — NOT NULL
- createdAt — datetime(6)
- updatedAt — datetime(6)
- content — varchar(255) — NOT NULL
- likeCount — int — NOT NULL
- post_no (Key) — bigint — Foreign key → Post.no — NOT NULL
- user_no (Key2) — bigint — Foreign key → User.no
Notification
- id (Key) — varchar(255) — Primary key — NOT NULL
- message — varchar(255)
- receiverId — varchar(255)
- senderId — varchar(255)
- type — tinyint
Post
- no (Key) — bigint — Primary key — NOT NULL
- createdAt — datetime(6)
- updatedAt — datetime(6)
- boardType — enum — NOT NULL
- bookmarkCount — int — NOT NULL
- commentCount — int — NOT NULL
- postContent — varchar(255) — NOT NULL
- postStatus — enum — NOT NULL
- postTitle — varchar(255) — NOT NULL
- viewCount — int — NOT NULL
- user_no (Key2) — bigint — Foreign key → User.no
Schedule
- no (Key) — bigint — Primary key — NOT NULL
- createdAt — datetime(6)
- createdBy — varchar(255)
- updatedAt — datetime(6)
- description — varchar(255)
- endDate — datetime(6)
- isAlertSent — bit — NOT NULL
- startDate — datetime(6)
- status — enum
- title — varchar(255)
- team_no (Key2) — bigint — Foreign key → teams.no
Tech
- no (Key) — bigint — Primary key — NOT NULL
- techName — varchar(255)
User
- no (Key) — bigint — Primary key
- createdAt — datetime(6)
- updatedAt — datetime(6)
- banned — bit — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- passwordErrorCount — int — NOT NULL
- phoneNum — varchar(255) — NOT NULL
- role — enum
- userStatus — enum — NOT NULL
- username — varchar(255) — NOT NULL
feedbacks
- no (Key) — bigint — Primary key — NOT NULL
- createdAt — datetime(6)
- updatedAt — datetime(6)
- content — varchar(255) — NOT NULL
- feedbackType — enum — NOT NULL
- project_no (Key2) — bigint — Foreign key → project.no — NOT NULL
- user_no (Key3) — bigint — Foreign key → User.no
likes
- like_no (Key2) — bigint — Primary key — NOT NULL
- comment_no (Key32) — bigint — Foreign key → Comment.no — NOT NULL
- user_no (Key3) — bigint — Foreign key → User.no
messages
- no (Key) — bigint — Primary key — NOT NULL
- sender_no — bigint — Primary key
- receiver_no (Key2) — bigint — Foreign key → User.no
- createdAt — datetime(6)
- updatedAt — datetime(6)
- content — tinytext — NOT NULL
- deletedByReceiver — bit — NOT NULL
- deletedBySender — bit — NOT NULL
- is_read — bit — NOT NULL
project
- no (Key) — bigint — Primary key — NOT NULL
- createdAt — datetime(6)
- updatedAt — datetime(6)
- content — varchar(255)
- name — varchar(255) — NOT NULL
- projectStatus — enum
- viewCnt — int — NOT NULL
- team_no (Key2) — bigint — Foreign key → teams.no
project_tech
- id (Key) — bigint — Primary key — NOT NULL
- project_no (Key2) — bigint — Foreign key → project.no — NOT NULL
- tech_no (Key3) — bigint — Foreign key → Tech.no — NOT NULL
report
- no (Key) — bigint — Primary key — NOT NULL
- createdAt — datetime(6)
- updatedAt — datetime(6)
- comment — tinytext — inytext nul
- content — tinytext — NOT NULL
- report_status — enum
- reportType — enum
- url — varchar(255)
- reported_no (Key4) — bigint — Foreign key → User.no
- reporter_no (Key5) — bigint — Foreign key → User.no
team_user
- no (Key) — bigint — Primary key — NOT NULL
- isLeader — bit — NOT NULL
- role — varchar(255)
- status — tinyint
- user_no (Key2) — bigint — Foreign key → User.no — NOT NULL
- team_no (Key3) — bigint — Foreign key → teams.no — NOT NULL
teams
- no (Key) — bigint — Primary key — NOT NULL
- projectStatus — enum
- teamIntroduce — varchar(255)
- teamName — varchar(255) — NOT NULL
user_tech
- no (Key) — bigint — Primary key — NOT NULL
- tech_no (Key2) — bigint — Foreign key → Tech.no — NOT NULL
- user_no (Key3) — bigint — Foreign key → User.no — NOT NULL