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