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