dangdang

Tables (9)

comment (Untitled)

  • id — varchar(255) — Primary key — NOT NULL
  • content — longtext
  • referenceId — bigint
  • comment_type — varchar(20)
  • depth — int
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • writer_nickname — varchar(30
  • writer_email — varchar(50
  • visable — bit
  • chlidren — List<comment>
  • writer_id — bigint — Foreign key → user.id

interview_question

  • id — bigint — Primary key
  • answer — longtext
  • field — varchar(25)
  • question — varchar(300)
  • visable — bit
  • writer — bigint — Foreign key → user.id

joins

  • id — bigint — Primary key
  • study_id — bigint — Foreign key → study.id
  • user_id — bigint — Foreign key → user.id
  • waiting — bit

post

  • id — bigint — Primary key
  • content — longtext
  • created_at — datetime(6)
  • title — varchar(300)
  • updated_at — datetime(6)
  • study_id — bigint
  • writer — bigint — Foreign key → user.id

resume

  • id — bigint — Primary key
  • writer — bigint — Foreign key → user.id

resume_question

  • id — bigint — Primary key
  • answer — longtext
  • question — varchar(300)
  • resume_id — bigint — Foreign key → resume.id

study

  • id — bigint — Primary key
  • created_at — datetime(6)
  • description — longtext
  • goal — varchar(30)
  • last_access_time — datetime(6)
  • name — varchar(30)
  • number — int
  • open_kakao — varchar(255)
  • total_time — int
  • host_id — bigint — Foreign key → user.id

study_hash_tag

  • id — bigint — Primary key
  • hash_tag — varchar(30)
  • study_id — bigint — Foreign key → study.id

user

  • id — bigint — Primary key
  • email — varchar(50) — NOT NULL
  • image_url — varchar(255)
  • nickname — varchar(30)
  • password — varchar(255)
  • provider — varchar(255)
  • provider_id — varchar(255)
  • role — varchar(255)