bowling

Tables (6)

t_address_verified

  • idx — AUTO increament — Primary key — NOT NULL
  • user_idx — NOT NULL — Foreign key → t_user.idx — NOT NULL
  • address — NOT NULL
  • verifiedCnt — default(0)
  • firstVerifiedDate — NOT NULL
  • lastVerifiedDate — NOT NULL

t_email_verified

  • user_idx — NOT NULL — Foreign key → t_user.idx — NOT NULL
  • verified (verfied) — NULL

t_push_tocken (t_push_token)

  • user_idx — NOT NULL — Foreign key → t_user.idx — NOT NULL
  • token — varchar(255)

t_refresh_token

  • user_idx — NOT NULL — Foreign key → t_user.idx — NOT NULL
  • token — varchar(255)

t_user

  • idx — NOT NULL — Primary key — NOT NULL
  • email — NOT NULL
  • pw — NOT NULL
  • nickname — NOT NULL
  • imgUrl — NULL
  • createdDate — NOT NULL
  • deletedDate (deletedData) — NULL
  • active — default(1)

t_user_setting

  • user_idx — NOT NULL — Foreign key → t_user.idx — NOT NULL
  • push_alarm — default(TRUE)