startupSereviceDesign
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
- shard_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
- 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
- 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 — 수정일자