test

Tables (9)

customer_profiles

  • user_id — BIGINT — Foreign key → users.id
  • shipping_address — VARCHAR(255)
  • membership_point — INT

permissions

  • id — BIGINT
  • action — VARCHAR(100) — NOT NULL

role_permissions

  • role_id — BIGINT — Foreign key → roles.id — NOT NULL
  • permission_id — BIGINT — Foreign key → permissions.id — NOT NULL

roles

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL

seller_profiles

  • user_id — BIGINT — Foreign key → users.id
  • company_name — VARCHAR(100) — NOT NULL
  • business_number — VARCHAR(50) — NOT NULL

skills

  • id — BIGINT
  • major_category — VARCHAR(50) — NOT NULL
  • minor_category — VARCHAR(50) — NOT NULL

user_roles

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • role_id — BIGINT — Foreign key → roles.id — NOT NULL

user_skills

  • user_id — UUID — Primary key — NOT NULL
  • skill_id — BIGINT — Foreign key → skills.id — NOT NULL
  • custom_detail — VARCHAR(100)

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP