MOYO
Tables (16)
BookMark
- post_no — bigint — Primary key — NOT NULL
- user_no — bigint — Primary key — NOT NULL
Comment
- no — bigint
- createdAt — datetime(6)
- updatedAt — datetime(6)
- content — varchar(255) — NOT NULL
- likeCount — int — NOT NULL
- post_no — bigint — NOT NULL
- user_no — bigint
Notification
- id — varchar(255) — NOT NULL
- message — varchar(255)
- receiverId — varchar(255)
- senderId — varchar(255)
- type — tinyint
Post
- no — bigint
- 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 — bigint
Schedule
- no — bigint
- 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 — bigint
Tech
- no — bigint
- techName — varchar(255)
User
- no — bigint
- 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 — bigint
- createdAt — datetime(6)
- updatedAt — datetime(6)
- content — varchar(255) — NOT NULL
- feedbackType — enum — NOT NULL
- project_no — bigint — NOT NULL
- user_no — bigint — NOT NULL
likes
- like_no — bigint
- comment_no — bigint — NOT NULL
- user_no — bigint
messages
- no — bigint
- createdAt — datetime(6)
- updatedAt — datetime(6)
- content — tinytext — NOT NULL
- deletedByReceiver — bit — NOT NULL
- deletedBySender — bit — NOT NULL
- is_read — bit — NOT NULL
- receiver_no — bigint
- sender_no — bigint
project
- no — bigint
- createdAt — datetime(6)
- updatedAt — datetime(6)
- content — varchar(255)
- name — varchar(255) — NOT NULL
- projectStatus — enum
- viewCnt — int — NOT NULL
- team_no — bigint
project_tech
- id — bigint
- project_no — bigint — NOT NULL
- tech_no — bigint — NOT NULL
report
- no — bigint
- createdAt — datetime(6)
- updatedAt — datetime(6)
- comment — tinytext — inytext nul
- content — tinytext — NOT NULL
- report_status — enum
- reportType — enum
- url — varchar(255)
- reported_no — bigint
- reporter_no — bigint
team_user
- no — bigint
- isLeader — bit — NOT NULL
- role — varchar(255)
- status — tinyint
- team_no — bigint — NOT NULL
- user_no — bigint — NOT NULL
teams
- no — bigint
- projectStatus — enum
- teamIntroduce — varchar(255)
- teamName — varchar(255) — NOT NULL
user_tech
- no — bigint
- tech_no — bigint — NOT NULL
- user_no — bigint — NOT NULL