test

Tables (5)

auth

  • id — BIGINT — Primary key — NOT NULL — PK
  • email — VARCHAR(255) — NOT NULL — 로그인 식별자
  • status — VARCHAR(20) — NOT NULL — ACTIVE(정상), INACTIVE(휴면), SUSPENDED(정지), WITHDRAWN(탈퇴)
  • role — VARCHAR(20) — NOT NULL — USER, SELLER, ADMIN
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • login_at — DATETIME — 마지막 로그인 시각(휴면 전환 판정용)
  • deleted_at — DATETIME

auth_local

  • id — BIGINT — Primary key — NOT NULL
  • auth_id — BIGINT — Foreign key → auth.id — NOT NULL
  • password — VARCHAR(255) — NOT NULL — BCrypt 해시
  • password_updated_at — DATETIME — 비밀번호 변경 주기 안내용
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

auth_social

  • id — BIGINT — Primary key — NOT NULL
  • auth_id — BIGINT — Foreign key → auth.id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL — KAKAO, NAVER, GOOGLE, APPLE
  • provider_id — VARCHAR(255) — NOT NULL — 제공자가 발급한 고유 식별자(sub)
  • email — VARCHAR(255) — 제공자가 내려준 원본 이메일. 미동의 시 NULL
  • created_at — DATETIME — NOT NULL

member

  • id — BIGINT — Primary key — NOT NULL
  • auth_id — BIGINT — Foreign key → auth.id — NOT NULL
  • nickname — VARCHAR(20) — 소셜 가입 시 미입력 가능
  • name — VARBINARY(256) — 고객명(암호화)
  • sex — VARCHAR(10) — MALE, FEMALE
  • phone_number — VARBINARY(256) — 01012345678 (암호화)
  • point — INT — NOT NULL
  • is_seller — BOOLEAN — NOT NULL — 조회 최적화용 비정규화. 진실은 auth.role
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

seller

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • business_name — VARCHAR(50) — NOT NULL — 상호명
  • business_number — VARCHAR(10) — NOT NULL — 사업자번호
  • mail_order_registration_number — VARCHAR(30) — NOT NULL — 통신판매업 신고번호
  • owner_name — VARCHAR(50) — NOT NULL — 대표자명
  • phone_number — VARCHAR(20) — NOT NULL
  • seller_status — VARCHAR(20) — NOT NULL — PENDING(승인대기), APPROVED(승인됨), BLOCKED(정지됨), WITHDRAWN(탈퇴)
  • approved_at — DATETIME — 판매자 승인 시각
  • bank_name — VARCHAR(50) — NOT NULL
  • bank_account — VARCHAR(50) — NOT NULL
  • depositor_name — VARCHAR(50) — NOT NULL — 예금주명
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME