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