mixin

Tables (13)

communityBookmark

  • id — BIGINT
  • community_id — BIGINT — NOT NULL
  • community_type — VARCHAR(50) — NOT NULL
  • user_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

communityComment

  • id — BIGINT
  • community_id — BIGINT — NOT NULL
  • community_type — VARCHAR(50) — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

communityLike

  • id — BIGINT
  • community_id — BIGINT — NOT NULL
  • community_type — VARCHAR(50) — NOT NULL
  • user_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

entityMappingImage

  • id — BIGINT
  • entity_type — VARCHAR(50) — NOT NULL
  • entity_id — BIGINT — NOT NULL
  • image_id — BIGINT — NOT NULL

image

  • id — BIGINT
  • image_url — VARCHAR(255) — NOT NULL

meet

  • id — BIGINT
  • type — VARCHAR(50) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • image — VARCHAR(255)
  • name — VARCHAR(255) — NOT NULL
  • info — VARCHAR(255)
  • rule — VARCHAR(255)
  • tag — VARCHAR(255)

meetAuthorization

  • id — BIGINT
  • meet_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • authorization — VARCHAR(50)

meetCommunity

  • id — BIGINT
  • meet_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

meetNotice

  • id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

noticeBookmark

  • id — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

profile

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • position — VARCHAR(50)
  • personality — VARCHAR(255)
  • interest — VARCHAR(255)
  • values — VARCHAR(255)
  • profile_image — VARCHAR(255)

publicCommunity

  • id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20)
  • school — VARCHAR(255)
  • gender — VARCHAR(10)
  • birth — DATE
  • student_number — VARCHAR(20)
  • major — VARCHAR(255)
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • telecom — VARCHAR(20)