Role Table

Overview

Table for managing role information

Table Definition

Logical Name	Physical Name	Column Name	Data Type	Primary Key	Relation	Unique	Nullable	Default Value	Remarks
Role Information	role	id	serial	◯
		name	string
		user_access	enum					'1'	access_level: '0' | '1' | '2'
		organization_access	enum					'1'	same
		project_access	enum					'1'	same
		admin_access	enum					'1'	same
		generated_code_access	enum					'1'	same

Indexes

• PRIMARY KEY (id)

Permission Levels

• 0: No access
• 1: Read
• 2: Read/Write

Notes

• Each *_access column uses PostgreSQL enum access_level ('0', '1', '2')
• Defaults are '1' (read) in packages/models/postgresql/role.ts