dobda

Tables (21)

Answer

  • id — bigint(20) — Primary key — NOT NULL
  • question_id — bigint(20) — NOT NULL
  • user_id — bigint(20) — NOT NULL — PK
  • 기능요청_id — bigint(20) — NOT NULL
  • content — varchar
  • isAccepted — Boolean

Notification

  • id — bigint(20) — Primary key — NOT NULL
  • receiver_id — bigint(20) — NOT NULL — PK
  • isRead — Boolean
  • type — enum
  • reference_id — bigint(20)
  • created_at — date

Photo

  • id — bigint(20) — Primary key — NOT NULL
  • question_id — bigint(20) — NOT NULL
  • url — varchar

Question

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — NOT NULL — PK
  • answer_id — bigint(20) — NOT NULL
  • title — varchar
  • content — varchar
  • watch — Int
  • coin — Int
  • isSolve — Boolean

QuestionTag

  • id — bigint(20) — Primary key — NOT NULL
  • tag_id — bigint(20) — NOT NULL
  • Question_id — bigint(20) — NOT NULL

Tag

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar

User

  • id — bigint(20) — Primary key — NOT NULL — PK
  • email — varchar
  • name — varchar
  • nickname — varchar
  • skill — json
  • coin — Int
  • score — Int
  • description — varchar
  • role — enum

addBell

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — NOT NULL — PK
  • Question_id — bigint(20) — NOT NULL

alarm (Untitled9)

    answer (Untitled4)

      coinHistory (Untitled11)

        coinReservation (Untitled12)

          comment (Untitled5)

            comment (Untitled7)

              enquiry (Untitled6)

                notice (Untitled8)

                  payment (Untitled10)

                    question (Untitled2)

                      sourcing (Untitled3)

                        sourcing

                        • id — bigint(20) — Primary key — NOT NULL
                        • user_id — bigint(20) — NOT NULL — PK
                        • answer_id — bigint(20) — NOT NULL
                        • title — varchar
                        • content — varchar
                        • watch — Int
                        • coin — Int
                        • deadline — date
                        • progress — enum

                        user (Untitled)