ISO/IEC 7816-7
Information technology - Identification cards - Integrated circuit(s) cards with contacts - Part 7: Interindustry commands for Structured Card Query Language (SCQL);
Foreword
Introduction
1 Scope
2 Normative references
3 Terms and definitions
3.1 database basic user
3.2 database file
3.3 database object owner
3.4 database owner
3.5 dictionary
3.6 system table
3.7 table
3.8 view
4 Symbols (and abbreviated terms)
5 SCQL database concept
5.1 SCQL database
Figure 1 - Application with a database in a multi-application card (example)
Figure 2 - SCQL database as part of a distributed SQL database environment (example)
5.2 SCQL tables
Figure 3 - SCQL table (example) and its main characteristics
5.3 SCQL views
Figure 4 - SCQL static view (example)
Figure 5 - SCQL dynamic view (example)
5.4 SCQL system tables and dictionaries
Figure 6 - Object description table
Figure 7 - User description table
Figure 8 - Privilege description table
5.5 SCQL user profiles
Table 1 - SCQL user profiles and attached permissions
* Profil User
* DB_O - Database owner
* DBOO -Database object owner
* DBBU - Database basic user with specific user id or the general user id PUBLIC
6 SCQL related commands
6.1 General aspects
Figure 9 - Mapping principle of a SQL statement onto a SCQL operation
6.2 Grouping and encoding of commands
Figure 10 - SCQL related commands
Table 2 - Instruction codes and operations
6.3 Notation and special codings
Table 3 - Coding of comparison operators
6.4 Status bytes
Table 4 - Status bytes
6.5 Coding of identifiers
6.6 Security attributes of tables, views and users
6.7 Linking user ids to INSERT and UPDATE operations
7 Database operations
7.1 CREATE TABLE
7.1.1 Definition and scope
7.1.2 Conditional usage and security
7.1.3 Command message
Table 5 - PERFORM SCQL OPERATION command APDU for CREATE TABLE
7.1.4 Response message
Table 6 - PERFORM SCQL OPERATION response APDU for CREATE TABLE
7.1.5 Status conditions
7.2 CREATE VIEW
7.3 CREATE DICTIONARY
7.4 DROP TABLE
7.5 DROP VIEW
7.6 GRANT
7.7 REVOKE
7.8 DECLARE CURSOR
7.9 OPEN
7.10 NEXT
7.11 FETCH
7.12 FETCH NEXT
7.13 INSERT
7.14 UPDATE
7.15 DELETE
8 Transaction management
8.1 General concept
8.2 Transaction operations
9 User management
9.1 General concept
9.2 User operations
Annex A - (informative) Usage of SCQL operations |