adsfa

Tables (6)

accounts

  • id — bigint — Primary key — NOT NULL — index id
  • uid — varchar(36) — NOT NULL — unique id
  • email — varchar(512) — NOT NULL — email
  • password — varchar(512) — NOT NULL — password
  • status — varchar(50) — NOT NULL — 회원 상태값
  • registered_at — datetime — 가입일자
  • created_at — datetime — 생성일자
  • updated_at — datetime — 수정일자

certificates

  • id — bigint — Primary key — NOT NULL — index id
  • public_key — text — NOT NULL — public_key
  • private_key — text — NOT NULL — private_key
  • encrypt_type — varchar(32) — NOT NULL — private_key
  • status — varchar(50) — NOT NULL — 회원 상태값
  • created_at — datetime — 생성일자
  • updated_at — datetime — 수정일자

sharded_shorturls

  • id — bigint — Primary key — NOT NULL — index id
  • uid — varchar(36) — NOT NULL — unique id
  • user_id — bigint — NOT NULL
  • user_uid — varchar(36) — NOT NULL — user uid
  • source — varchar(512) — NOT NULL — access_token
  • shorturl — varchar(512) — NOT NULL — refresh_token
  • shard_id — int — logical_shard_id
  • status — varchar(50) — NOT NULL — 회원상태값
  • created_at — datetime — 생성일자
  • updated_at — datetime — 수정일자

shorturls

  • id — bigint — Primary key — NOT NULL — index id
  • uid — varchar(36) — NOT NULL — unique id
  • user_id — bigint — NOT NULL
  • user_uid — varchar(36) — NOT NULL — user uid
  • source — varchar(512) — NOT NULL — access_token
  • shorturl — varchar(512) — NOT NULL — refresh_token
  • shard_id — int — logical_shard_id
  • status — varchar(50) — NOT NULL — 회원상태값
  • created_at — datetime — 생성일자
  • updated_at — datetime — 수정일자

tokens

  • id — bigint — Primary key — NOT NULL — index id
  • uid — varchar(36) — NOT NULL — unique id
  • user_id — bigint — NOT NULL
  • user_uid — varchar(36) — NOT NULL — user uid
  • access_token — varchar(512) — NOT NULL — access_token
  • refresh_token — varchar(512) — NOT NULL — refresh_token
  • status — varchar(50) — NOT NULL — 회원상태값
  • access_token_expired_at — datetime — 액세스토큰만료일자
  • refresh_token_expired_at — datetime — 리프레시토큰만료일자
  • request_ip — varchar(32) — NOT NULL — ip
  • created_at — datetime — 생성일자
  • updated_at — datetime — 수정일자

visit_history

  • id — bigint — Primary key — NOT NULL — index id
  • uid — varchar(36) — NOT NULL — unique id
  • shorturl_id — bigint — NOT NULL
  • shorturl_uid — varchar(36) — NOT NULL
  • request_ip — varchar(32) — ip
  • agent — varchar(512) — agent
  • status — varchar(50) — NOT NULL
  • created_at — datetime — 생성일자
  • updated_at — datetime — 수정일자