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