mojire

Tables (13)

Untitled (inquiry)

  • id — bigint(20) — Primary key — NOT NULL
  • createdAt — datetime(6)
  • updatedAt (updated_at) — datetime(6)
  • title — varchar(255)
  • content — varchar(255)
  • status — varchar(255)
  • id (user_id) — bigint(20) — Foreign key → user.id — NOT NULL

Untitled (bookmark)

  • id — bigint(20) — Primary key — NOT NULL
  • id (user_id) — bigint(20) — Foreign key → user.id
  • id (board_id) — bigint(20) — Foreign key → Untitled.id

Untitled (board)

  • id (board_id) — bigint(20) — Primary key — NOT NULL
  • title — varchar(45) — NOT NULL
  • thumbnail — bigtext
  • content — mediumtext — NOT NULL
  • id (user_id) — bigint(20) — Foreign key → user.id — NOT NULL
  • id (category_id) — bigint(20) — Foreign key → category.id — NOT NULL
  • hotBoard (hot_board) — bit(1)
  • likeCount (like_count) — bigint(20) — NOT NULL

Untitled (boardImage)

  • id (board_image_id) — bigint(20) — Primary key — NOT NULL
  • id (board_id) — bigint(20) — Foreign key → Untitled.id — NOT NULL
  • imageUrl (image_url) — bigtext — NOT NULL

Untitled (boardLike)

  • id — bigint(20) — Primary key — NOT NULL
  • isLike (is_like) — bit(1)
  • id (user_id) — bigint(20) — Foreign key → user.id
  • id (board_id) — bigint(20) — Foreign key → Untitled.id

Untitled (boardViews)

  • boardViewsId (board_views_id) — bigint(20) — Primary key — NOT NULL
  • clientIpAddress (client_ip_address) — varchar(255)
  • id (board_id) — bigint(20) — Foreign key → Untitled.id — NOT NULL
  • viewAt (view_at) — datetime(6) — NOT NULL

bungae

  • id (bungae_id) — bigint(20) — Primary key — NOT NULL
  • createdAt (created_at) — datetime(6)
  • updatedAt (updated_at) — datetime(6)
  • title — varchar(30)
  • content — bigtext
  • place — bigtext
  • recuritingMembers (recuriting_members) — int
  • deadline (dealine) — datetime(6)
  • status — varchar(255)
  • id (category_id) — bigint(20) — Foreign key → category.id
  • id (user_id) — bigint(20) — Foreign key → user.id

category

  • id (category_id) — bigint(20) — Primary key — NOT NULL
  • createdAt (created_at) — datetime(6)
  • updatedAt (updated_at) — datetime(6)
  • name — varchar(45) — NOT NULL
  • imageUrl (image_url) — longtext — NOT NULL
  • detail — longtext — NOT NULL

member

  • id (member_id) — bigint(20) — Primary key — NOT NULL
  • createAt (creaet_at) — datetime(6)
  • updatedAt (updated_at) — datetime(6)
  • id (user_id) — bigint(20) — Foreign key → user.id — NOT NULL
  • id (bungae_id) — bigint(20) — Foreign key → bungae.id — NOT NULL

report

  • id (report_id) — Primary key — NOT NULL
  • createdAt (created_at) — datetime(6)
  • updatedAt (updated_at) — datetime(6)
  • contents — bigtext
  • id (user_id) — bigint(20) — Foreign key → user.id — NOT NULL
  • id (target_user_id) — bigint(20) — Foreign key → user.id — NOT NULL

user

  • id (user_id) — bigint(20) — Primary key — NOT NULL
  • email — varchar(45) — NOT NULL
  • password — varchar(255) — NOT NULL
  • nickname — varchar(45)
  • number — bigint(20) — unique
  • grade — bigint(20)
  • department — varchar(45)
  • image (image_url) — longtext
  • bio — longtext
  • instagram — varchar(45)
  • anonymity — bit(1)

user_category (likes)

  • id (likes_id) — bigint(20) — Primary key — NOT NULL
  • id (user_id) — bigint(20) — Foreign key → user.id
  • id (category_id) — bigint(20) — Foreign key → category.id

user_roles

  • id (user_user_id) — bigint(20) — Foreign key → user.id — NOT NULL
  • roles — varchar(255)