emart_2
Tables (4)
emart_user
- user_id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- gender — VARCHAR(20)
- birth — DATE
- phone — VARCHAR(20)
- use_terms — VARCHAR(255)
- created_at — DATETIME
- role_id — INT — Foreign key → roles.role_id — NOT NULL — roles.role_id FK
permissions
- permission_id — INT — Primary key — NOT NULL
- role_id — INT — Foreign key → roles.role_id — NOT NULL — roles.role_id FK
- resource — VARCHAR(50) — NOT NULL — 자원 (product, order, user...)
- action — VARCHAR(20) — NOT NULL — READ, CREATE, UPDATE, DELETE
- description — VARCHAR(255)
roles
- role_id — INT — Primary key — NOT NULL
- role_name — VARCHAR(50) — NOT NULL — 역할 이름
- role_key — VARCHAR(30) — NOT NULL — 역할 키 (ROLE_USER 등)
- description — VARCHAR(255)
seller_profile
- seller_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL — emart_user.user_id FK
- seller_name — VARCHAR(255) — 이름
- phone_number — VARCHAR(20) — 휴대폰 번호
- registered_at — DATETIME — 등록일시
- verified_email — VARCHAR(255) — 확인된 이메일
- verified_birth — DATE — 확인된 생년월일
- status — VARCHAR(20) — PENDING, APPROVED, REJECTED
- created_at — DATETIME
- updated_at — DATETIME
- user_id (user_id2) — INT — Foreign key → emart_user.user_id — NOT NULL
- permission_id — INT — Foreign key → permissions.permission_id — NOT NULL