Bside

Tables (6)

BEDGE (뱃지)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • image_url (Field2) — varchar(250)
  • qualification (Field3) — varchar(100)
  • explanation (Field4) — varchar(250)
  • reg_dtm (Field5) — timestamp
  • mod_dtm (Field6) — timestamp

CHEER_UP_MESSAGE (응원메세지)

  • id (Key) — bigint — Primary key — NOT NULL
  • not_to_do_id (FK) — bigint — Foreign key → USER_NOT_TO_DO.id — NOT NULL
  • user_id (FK2) — bigint — Foreign key → USER_NOT_TO_DO.user_id — NOT NULL
  • content (Field) — varchar(200)
  • use_yn (Field2) — boolean
  • reg_dtm (Field3) — timestamp
  • mod_dtm (Field4) — timestamp

MODERATION_RECORD (절제기록)

  • id (Key) — bigint — Primary key — NOT NULL
  • not_to_do_id (FK) — bigint — Foreign key → USER_NOT_TO_DO.id — NOT NULL
  • user_id (FK2) — bigint — Foreign key → USER_NOT_TO_DO.user_id — NOT NULL
  • content (Field) — text
  • success_yn (Field2) — boolean
  • record_date (Field3) — varchar(10)
  • reg_dtm (Field4) — timestamp
  • mod_dtm (Field5) — timestamp

USER (사용자)

  • id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — varchar(30)
  • nickname (Field2) — varchar(20)
  • refresh_token (Field3)
  • app_push_yn (Field4) — boolean
  • tos_yn (Field5) — boolean
  • not_to_do_cnt (Field6) — int
  • use_yn (Field7) — boolean
  • reg_dtm (Field8) — timestamp
  • mod_dtm (Field9) — timestamp

USER_BEDGE (사용자 뱃지)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → USER.id — NOT NULL
  • bedge_id (FK2) — bigint — Foreign key → BEDGE.id — NOT NULL
  • get_cnt (Field) — int
  • reg_dtm (Field2) — timestamp

USER_NOT_TO_DO (사용자 낫투두)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (PK) — bigint — Foreign key → USER.id — NOT NULL
  • not_to_do_text (Field2) — varchar(100)
  • goal (Field3) — varchar(100)
  • progress_state (Field4) — varchar(10)
  • success_yn (Field5) — boolean
  • start_date (Field6) — timestamp
  • end_date (Field7) — timestamp
  • total_challenge_days (Field8) — int
  • current_challenge_days (Field9) — int
  • use_yn (Field10) — boolean
  • reg_dtm (Field11) — timestamp
  • mod_dtm (Field12) — timestamp