1. 個人情報（PII）
#### ユーザープロフィール
```json
{
"id": "usr_7f3k9m2p",
"firstName": "太郎",
"lastName": "山田",
"email": "taro.yamada.test@example.com",
"phone": "090-1234-5678",
"dateOfBirth": "1990-05-15",
"address": {
"country": "Japan",
"postalCode": "150-0001",
"prefecture": "東京都",
"city": "渋谷区",
"street": "神宮前1-2-3",
"building": "テストビル 405号室"
},
"createdAt": "2023-01-15T10:30:00Z",
"lastLogin": "2024-11-20T14:22:33Z"
}
```
#### 企業情報
```json
{
"companyId": "com_9x4j2k7n",
"companyName": "テックイノベーション株式会社",
"industry": "IT・ソフトウェア",
"employeeCount": 250,
"founded": "2015-04-01",
"website": "https://techinnovation-test.example.com",
"email": "info@techinnovation-test.example.com",
"phone": "03-1234-5678",
"address": {
"country": "Japan",
"postalCode": "100-0001",
"prefecture": "東京都",
"city": "千代田区",
"street": "丸の内1-1-1"
}
}
```
2. トランザクションデータ
#### 購買データ
```json
{
"orderId": "ord_20241122_001",
"customerId": "usr_7f3k9m2p",
"orderDate": "2024-11-22T09:15:00Z",
"status": "completed",
"items": [
{
"productId": "prod_laptop_001",
"productName": "ノートパソコン ProBook 15",
"category": "Electronics",
"quantity": 1,
"unitPrice": 89800,
"discount": 5000,
"subtotal": 84800
},
{
"productId": "prod_mouse_042",
"productName": "ワイヤレスマウス",
"category": "Accessories",
"quantity": 2,
"unitPrice": 2980,
"discount": 0,
"subtotal": 5960
}
],
"subtotal": 90760,
"tax": 9076,
"shipping": 0,
"total": 99836,
"paymentMethod": "credit_card",
"shippingAddress": {
"name": "山田 太郎",
"postalCode": "150-0001",
"prefecture": "東京都",
"city": "渋谷区",
"street": "神宮前1-2-3",
"phone": "090-1234-5678"
}
}
```
#### 決済データ
```json
{
"transactionId": "txn_20241122_001",
"orderId": "ord_20241122_001",
"amount": 99836,
"currency": "JPY",
"paymentMethod": "credit_card",
"cardLast4": "1234",
"cardBrand": "VISA",
"status": "succeeded",
"timestamp": "2024-11-22T09:16:12Z",
"gatewayResponse": {
"authCode": "AUTH123456",
"transactionRef": "ref_abc123xyz"
}
}
```
3. ログデータ
#### アプリケーションログ
```json
{
"timestamp": "2024-11-22T10:15:32.456Z",
"level": "INFO",
"service": "user-service",
"environment": "production",
"traceId": "trace_7f3k9m2p4j",
"spanId": "span_2x9k4n",
"userId": "usr_7f3k9m2p",
"action": "user.login",
"message": "User logged in successfully",
"metadata": {
"ipAddress": "192.168.1.100",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64)",
"sessionId": "sess_abc123xyz"
},
"duration": 234
}
```
#### エラーログ
```json
{
"timestamp": "2024-11-22T10:16:45.789Z",
"level": "ERROR",
"service": "payment-service",
"environment": "production",
"traceId": "trace_err_5k2m9p",
"error": {
"type": "PaymentGatewayError",
"message": "Payment gateway timeout",
"code": "GATEWAY_TIMEOUT",
"stack": "at processPayment (payment.js:45:12)..."
},
"context": {
"orderId": "ord_20241122_002",
"amount": 15000,
"retryCount": 2
}
}
```
#### アクセスログ（Apache/Nginx形式）
```
192.168.1.100 - - [22/Nov/2024:10:15:32 +0900] "GET /api/users/profile HTTP/1.1" 200 1234 "https://example.com/dashboard" "Mozilla/5.0 (Windows NT 10.0; Win64; x64)" 0.234
192.168.1.101 - - [22/Nov/2024:10:15:33 +0900] "POST /api/orders HTTP/1.1" 201 567 "https://example.com/cart" "Mozilla/5.0 (Macintosh; Intel Mac OS X)" 0.567
192.168.1.102 - - [22/Nov/2024:10:15:34 +0900] "GET /api/products?category=electronics HTTP/1.1" 200 8901 "-" "PostmanRuntime/7.26.8" 0.123
```
4. 時系列データ
#### センサーデータ
```json
{
"deviceId": "sensor_temp_001",
"location": "Building A - Room 301",
"measurements": [
{
"timestamp": "2024-11-22T10:00:00Z",
"temperature": 22.5,
"humidity": 45.2,
"pressure": 1013.25
},
{
"timestamp": "2024-11-22T10:05:00Z",
"temperature": 22.7,
"humidity": 45.0,
"pressure": 1013.30
},
{
"timestamp": "2024-11-22T10:10:00Z",
"temperature": 22.9,
"humidity": 44.8,
"pressure": 1013.28
}
]
}
```
#### メトリクスデータ
```json
{
"service": "api-gateway",
"metrics": [
{
"timestamp": "2024-11-22T10:00:00Z",
"requestsPerSecond": 1250,
"averageLatency": 45,
"p95Latency": 120,
"p99Latency": 250,
"errorRate": 0.2,
"cpuUsage": 45.5,
"memoryUsage": 62.3
}
]
}
```
5. APIレスポンスデータ
#### REST APIレスポンス
```json
{
"status": "success",
"data": {
"users": [
{
"id": 1,
"name": "山田太郎",
"email": "taro@example.com",
"role": "admin"
},
{
"id": 2,
"name": "鈴木花子",
"email": "hanako@example.com",
"role": "user"
}
],
"pagination": {
"page": 1,
"perPage": 20,
"total": 150,
"totalPages": 8
}
},
"meta": {
"requestId": "req_abc123",
"timestamp": "2024-11-22T10:15:32Z",
"version": "v1"
}
}
```
#### GraphQLレスポンス
```json
{
"data": {
"user": {
"id": "usr_123",
"name": "山田太郎",
"email": "taro@example.com",
"posts": [
{
"id": "post_001",
"title": "初めての投稿",
"content": "こんにちは、これは私の最初の投稿です。",
"createdAt": "2024-11-20T10:00:00Z",
"likes": 42
}
]
}
}
}
```
6. 関係データ（正規化DB用）
#### Users テーブル
```sql
INSERT INTO users (id, email, name, created_at) VALUES
(1, 'user1@example.com', '山田太郎', '2024-01-15 10:30:00'),
(2, 'user2@example.com', '鈴木花子', '2024-01-16 11:45:00'),
(3, 'user3@example.com', '佐藤次郎', '2024-01-17 09:20:00');
```
#### Orders テーブル（外部キー関係）
```sql
INSERT INTO orders (id, user_id, total_amount, status, created_at) VALUES
(1, 1, 99836, 'completed', '2024-11-22 09:15:00'),
(2, 1, 15000, 'pending', '2024-11-22 14:30:00'),
(3, 2, 45000, 'completed', '2024-11-22 10:00:00');
```
#### Order_Items テーブル
```sql
INSERT INTO order_items (id, order_id, product_id, quantity, unit_price) VALUES
(1, 1, 101, 1, 89800),
(2, 1, 102, 2, 2980),
(3, 2, 103, 1, 15000),
(4, 3, 104, 3, 15000);
```
|