springboot4-market
Tables (7)
Users (고객)
- id (키) — int — Primary key — NOT NULL
- email (유저이메일) — varchar(255)
- user_email (유저이메일(가상컬럼)) — user_email VARCHAR(255) GENERATED ALWAYS AS ( CASE WHEN status = 'ACTIVE' THEN email ELSE NULL END ) STORED
- password (비밀번호) — varchar(255)
- username (유저 이름) — varchar(50)
- provider (소셜기업들) — ENUM('LOCAL','GOOGLE','KAKAO','NAVER')
- provider_user_id (소셜유저식별id) — VARCHAR(255)
- status (회원 상태) — ENUM('ACTIVE','DELETED','SUSPENDED') NOT NULL DEFAULT 'ACTIVE'
- created_at (회원 생성 날찌) — TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
- deleted_at (회원 탈퇴 날짜) — timestamp CHECK ( (status = 'DELETED' AND deleted_at IS NOT NULL) OR (status <> 'DELETED' AND deleted_at IS NULL) )
Users (고객1)
- id (키) — int — Primary key — NOT NULL
- email (유저이메일) — varchar(255)
- password (비밀번호) — varchar(255)
- username (유저 이름) — varchar(50)
- status (회원 상태) — ENUM('ACTIVE','DELETED','SUSPENDED') NOT NULL DEFAULT 'ACTIVE'
- created_at (회원 생성 날찌) — TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
- deleted_at (회원 탈퇴 날짜) — timestamp CHECK ( (status = 'DELETED' AND deleted_at IS NOT NULL) OR (status <> 'DELETED' AND deleted_at IS NULL) )