SM

Tables (7)

Untitled

  • id (Key) — long — Primary key — NOT NULL
  • createdAt (Field) — date
  • Field2

app_user

  • referral_score — integer
  • social_score — integer
  • created_at — timestamp(6)
  • id — bigint — NOT NULL
  • referred_by_id — bigint
  • account_type — character
  • email — character
  • name — character
  • password — character
  • phone_number — character
  • role — character
  • username — character
  • GOOGLE::character — varying
  • APPLE::character — varying
  • KAKAO::character — varying
  • NAVER::character — varying)::text)))
  • MEMBER::character — varying
  • SYSTEM::character — varying)::text)))

category

  • can_add_children — boolean
  • can_be_deleted — boolean
  • can_change_name — boolean
  • created_at — timestamp(6)
  • id — bigint — NOT NULL
  • name_value_id — bigint
  • parent_id — bigint
  • category_type — character
  • CURATOR::character — varying
  • SGM_NEWS::character — varying
  • STORE::character — varying)::text)))

file_info

  • created_at — timestamp(6)
  • id — bigint — NOT NULL
  • file_type — character
  • url — character
  • JPEG::character — varying
  • JPG::character — varying)::text)))

localized_text

  • id — bigint — NOT NULL
  • cn — character
  • en — character
  • jp — character
  • kr — character

otpinfo

  • created_at — timestamp(6)
  • expired_at — timestamp(6)
  • id — bigint — NOT NULL
  • address — character
  • auth_method — character
  • code — character
  • otp_session_id — character
  • EMAIL::character — varying
  • PASSWORD::character — varying)::text)))

refresh_token

  • app_user_id — bigint
  • created_at — timestamp(6)
  • expired_at — timestamp(6)
  • id — bigint — NOT NULL
  • content — character