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