SQL test 00 - test data

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109

-- 1. 對應 anime-dataset-2023.csv
CREATE TABLE ANIME_DATASET_2023 (
    ANIME_ID NUMBER PRIMARY KEY,
    NAME NVARCHAR2(500),
    ENGLISH_NAME NVARCHAR2(500),
    OTHER_NAME NVARCHAR2(500),
    SCORE NUMBER(5,2),
    GENRES NVARCHAR2(1000),
    SYNOPSIS CLOB,
    TYPE NVARCHAR2(50),
    EPISODES NUMBER,
    AIRED NVARCHAR2(100),
    PREMIERED NVARCHAR2(100),
    STATUS NVARCHAR2(100),
    PRODUCERS NVARCHAR2(1000),
    LICENSORS NVARCHAR2(1000),
    STUDIOS NVARCHAR2(1000),
    SOURCE NVARCHAR2(100),
    DURATION NVARCHAR2(100),
    RATING NVARCHAR2(200),
    RANK NUMBER,
    POPULARITY NUMBER,
    FAVORITES NUMBER,
    SCORED_BY NUMBER,
    MEMBERS NUMBER,
    IMAGE_URL NVARCHAR2(1000)
);

-- 2. 對應 anime-filtered.csv
CREATE TABLE ANIME_FILTERED (
    ANIME_ID NUMBER PRIMARY KEY,
    NAME NVARCHAR2(500),
    SCORE NUMBER(5,2),
    GENRES NVARCHAR2(1000),
    ENGLISH_NAME NVARCHAR2(500),
    JAPANESE_NAME NVARCHAR2(500),
    SYPNOPSIS CLOB,
    TYPE NVARCHAR2(50),
    EPISODES NUMBER,
    AIRED NVARCHAR2(100),
    PREMIERED NVARCHAR2(100),
    PRODUCERS NVARCHAR2(1000),
    LICENSORS NVARCHAR2(1000),
    STUDIOS NVARCHAR2(1000),
    SOURCE NVARCHAR2(100),
    DURATION NVARCHAR2(100),
    RATING NVARCHAR2(200),
    RANKED NUMBER,
    POPULARITY NUMBER,
    MEMBERS NUMBER,
    FAVORITES NUMBER,
    WATCHING NUMBER,
    COMPLETED NUMBER,
    ON_HOLD NUMBER,
    DROPPED NUMBER
);

-- 3. 對應 final_animedataset.csv
CREATE TABLE FINAL_ANIMEDATASET (
    USERNAME NVARCHAR2(255),
    ANIME_ID NUMBER,
    MY_SCORE NUMBER,
    USER_ID NUMBER,
    GENDER NVARCHAR2(50),
    TITLE NVARCHAR2(500),
    TYPE NVARCHAR2(50),
    SOURCE NVARCHAR2(100),
    SCORE NUMBER(5,2),
    SCORED_BY NUMBER,
    RANK NUMBER,
    POPULARITY NUMBER,
    GENRE NVARCHAR2(1000)
);

-- 4. 對應 user-filtered.csv
CREATE TABLE USER_FILTERED (
    USER_ID NUMBER,
    ANIME_ID NUMBER,
    RATING NUMBER
);

-- 5. 對應 users-details-2023.csv
CREATE TABLE USERS_DETAILS_2023 (
    MAL_ID NUMBER PRIMARY KEY,
    USERNAME NVARCHAR2(255),
    GENDER NVARCHAR2(50),
    BIRTHDAY NVARCHAR2(100),
    LOCATION NVARCHAR2(500),
    JOINED NVARCHAR2(100),
    DAYS_WATCHED NUMBER(10,2),
    MEAN_SCORE NUMBER(5,2),
    WATCHING NUMBER,
    COMPLETED NUMBER,
    ON_HOLD NUMBER,
    DROPPED NUMBER,
    PLAN_TO_WATCH NUMBER,
    TOTAL_ENTRIES NUMBER,
    REWATCHED NUMBER,
    EPISODES_WATCHED NUMBER
);

-- 6. 對應 users-score-2023.csv
CREATE TABLE USERS_SCORE_2023 (
    USER_ID NUMBER,
    USERNAME NVARCHAR2(255),
    ANIME_ID NUMBER,
    ANIME_TITLE NVARCHAR2(500),
    RATING NUMBER
);

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140

erDiagram
        ANIME_DATASET_2023 {
            NUMBER ANIME_ID PK "動畫唯一識別 ID"
            NVARCHAR2_1000 NAME "動畫原始語言名稱"
            NVARCHAR2_1000 ENGLISH_NAME "動畫英文名稱"
            NVARCHAR2_1000 OTHER_NAME "動畫其他名稱"
            NUMBER SCORE "動畫平均評分"
            NVARCHAR2_2000 GENRES "動畫類型風格"
            CLOB SYNOPSIS "動畫劇情簡介"
            NVARCHAR2_100 TYPE "動畫播放類型"
            NUMBER EPISODES "總集數"
            NVARCHAR2_200 AIRED "播出日期範圍"
            NVARCHAR2_200 PREMIERED "首播季度與年份"
            NVARCHAR2_200 STATUS "播出狀態"
            NVARCHAR2_2000 PRODUCERS "製作人/企劃公司"
            NVARCHAR2_2000 LICENSORS "版權代理商/授權平台"
            NVARCHAR2_2000 STUDIOS "動畫製作公司"
            NVARCHAR2_200 SOURCE "原作來源"
            NVARCHAR2_200 DURATION "單集播映時間"
            NVARCHAR2_400 RATING "家長分級"
            NUMBER RANK "評分排名"
            NUMBER POPULARITY "人氣排名"
            NUMBER FAVORITES "被收藏為最愛人數"
            NUMBER SCORED_BY "參與評分的使用者總數"
            NUMBER MEMBERS "將此動畫加入清單人數"
            NVARCHAR2_2000 IMAGE_URL "動畫封面海報連結"
        }
    
        ANIME_FILTERED {
            NUMBER ANIME_ID PK "動畫唯一識別 ID"
            NVARCHAR2_1000 NAME "動畫名稱"
            NUMBER SCORE "動畫平均評分"
            NVARCHAR2_2000 GENRES "動畫類型風格"
            NVARCHAR2_1000 ENGLISH_NAME "動畫英文名稱"
            NVARCHAR2_1000 JAPANESE_NAME "動畫日文原名"
            CLOB SYPNOPSIS "動畫劇情簡介 (欄位拼寫為 SYPNOPSIS)"
            NVARCHAR2_100 TYPE "動畫播放類型"
            NUMBER EPISODES "總集數"
            NVARCHAR2_200 AIRED "播出日期範圍"
            NVARCHAR2_200 PREMIERED "首播季度與年份"
            NVARCHAR2_2000 PRODUCERS "製作人/企劃公司"
            NVARCHAR2_2000 LICENSORS "版權代理商/授權平台"
            NVARCHAR2_2000 STUDIOS "動畫製作公司"
            NVARCHAR2_200 SOURCE "原作來源"
            NVARCHAR2_200 DURATION "單集播映時間"
            NVARCHAR2_400 RATING "家長分級"
            NUMBER RANKED "評分排名 (欄位拼寫為 RANKED)"
            NUMBER POPULARITY "人氣排名"
            NUMBER MEMBERS "將此動畫加入清單人數"
            NUMBER FAVORITES "被收藏為最愛人數"
            NUMBER WATCHING "目前正在觀看人數"
            NUMBER COMPLETED "已經看完人數"
            NUMBER ON_HOLD "暫停觀看人數"
            NUMBER DROPPED "已棄追人數"
        }
    
        USERS_DETAILS_2023 {
            NUMBER MAL_ID PK "使用者唯一識別 ID"
            NVARCHAR2_510 USERNAME UK "使用者帳號名稱"
            NVARCHAR2_100 GENDER "性別"
            NVARCHAR2_200 BIRTHDAY "生日"
            NVARCHAR2_1000 LOCATION "居住地或國家"
            NVARCHAR2_200 JOINED "加入平台日期"
            NUMBER DAYS_WATCHED "總計觀看動漫天數"
            NUMBER MEAN_SCORE "平均分數"
            NUMBER WATCHING "正在觀看動畫數"
            NUMBER COMPLETED "已看完動畫數"
            NUMBER ON_HOLD "暫停觀看動畫數"
            NUMBER DROPPED "已棄追動畫數"
            NUMBER PLAN_TO_WATCH "計畫觀看動畫數"
            NUMBER TOTAL_ENTRIES "清單動漫總數"
            NUMBER REWATCHED "重複觀看動畫數"
            NUMBER EPISODES_WATCHED "累計觀看集數"
        }
    
        USERS_SCORE_2023 {
            NUMBER USER_ID FK "使用者 ID (對應 MAL_ID)"
            NVARCHAR2_510 USERNAME "使用者帳號名稱"
            NUMBER ANIME_ID FK "動畫 ID (對應 ANIME_ID)"
            NVARCHAR2_1000 ANIME_TITLE "動畫標題"
            NUMBER RATING "評分 (1-10)"
        }
    
        USER_FILTERED {
            NUMBER USER_ID FK "使用者 ID (對應 MAL_ID)"
            NUMBER ANIME_ID FK "動畫 ID (對應 ANIME_ID)"
            NUMBER RATING "評分 (0-10)"
        }
    
        FINAL_ANIMEDATASET {
            NVARCHAR2_510 USERNAME "使用者帳號名稱"
            NUMBER ANIME_ID FK "動畫 ID (對應 ANIME_ID)"
            NUMBER MY_SCORE "評分 (0-10)"
            NUMBER USER_ID FK "使用者 ID (對應 MAL_ID)"
            NVARCHAR2_100 GENDER "使用者性別"
            NVARCHAR2_1000 TITLE "動畫標題"
            NVARCHAR2_100 TYPE "動畫類型"
            NVARCHAR2_200 SOURCE "原作來源"
            NUMBER SCORE "平台平均評分"
            NUMBER SCORED_BY "平台評分人數"
            NUMBER RANK "平台評分排名"
            NUMBER POPULARITY "平台人氣排名"
            NVARCHAR2_2000 GENRE "動畫風格類型"
        }
    
        GOV_DATASET_REGISTRY {
            NUMBER OBJID PK "紀錄唯一識別碼"
            NUMBER DATASET_ID "開放資料集 ID"
            NVARCHAR2_400 DATASET_NAME "資料集名稱"
            NVARCHAR2_100 DATA_PROVIDER_ATTR "資料提供者屬性"
            NVARCHAR2_100 SERVICE_CATEGORY "服務分類"
            NVARCHAR2_40 QUALITY_CHECK "品質檢驗狀態"
            NVARCHAR2_200 FILE_FORMAT "資料檔案格式"
            VARCHAR2_2000 DOWNLOAD_URL "資料下載網址"
            NVARCHAR2_200 ENCODING_FORMAT "字元編碼格式"
            NVARCHAR2_100 PUBLISH_METHOD "發布方式描述"
            NVARCHAR2_4000 DATASET_DESC "資料集詳細說明"
            NVARCHAR2_4000 MAIN_FIELDS "主要欄位說明"
            NVARCHAR2_200 PROVIDER_AGENCY "資料提供機關"
            NVARCHAR2_100 UPDATE_FREQUENCY "資料更新頻率"
            NVARCHAR2_200 LICENSE_TYPE "授權類型說明"
            VARCHAR2_1000 RELATED_URL "相關連結網址"
            NVARCHAR2_100 BILLING_TYPE "計費方式"
            NVARCHAR2_100 CONTACT_NAME "聯絡人姓名"
            NVARCHAR2_100 CONTACT_PHONE "聯絡人電話"
            DATE PUBLISH_DATE "發布日期"
            DATE METADATA_UPDATE_TIME "中介資料更新時間"
            NVARCHAR2_4000 REMARKS "備註"
            NVARCHAR2_200 DATA_VOLUME "資料量描述"
        }

        %% 關聯定義
        ANIME_DATASET_2023 ||--o| ANIME_FILTERED : "1 對 0或1 (ANIME_ID)"
        ANIME_DATASET_2023 ||--o{ USERS_SCORE_2023 : "1 對 多 (ANIME_ID)"
        ANIME_DATASET_2023 ||--o{ USER_FILTERED : "1 對 多 (ANIME_ID)"
        ANIME_DATASET_2023 ||--o{ FINAL_ANIMEDATASET : "1 對 多 (ANIME_ID)"
        
        USERS_DETAILS_2023 ||--o{ USERS_SCORE_2023 : "1 對 多 (MAL_ID = USER_ID)"
        USERS_DETAILS_2023 ||--o{ USER_FILTERED : "1 對 多 (MAL_ID = USER_ID)"
        USERS_DETAILS_2023 ||--o{ FINAL_ANIMEDATASET : "1 對 多 (MAL_ID = USER_ID)"

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147

-- MyAnimeList 2023 Database Schema DDL Comments
    -- Schema Name: POLLO
    -- Date: 2026-06-20
    
    -- =========================================================================
    -- 1. POLLO.ANIME_DATASET_2023 (2023 年動畫完整元數據表)
    -- =========================================================================
    COMMENT ON TABLE POLLO.ANIME_DATASET_2023 IS '2023 年動畫完整元數據表 (未篩選)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.ANIME_ID IS '動畫唯一識別 ID (主鍵)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.NAME IS '動畫原始語言名稱 (如日文或羅馬拼音)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.ENGLISH_NAME IS '動畫英文名稱';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.OTHER_NAME IS '動畫其他名稱 (如日文原名或別名)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.SCORE IS '動畫平均評分 (1-10)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.GENRES IS '動畫類型/風格 (逗號分隔)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.SYNOPSIS IS '動畫劇情簡介';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.TYPE IS '動畫類型 (如 TV, Movie, OVA, Special 等)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.EPISODES IS '總集數';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.AIRED IS '播出日期範圍描述';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.PREMIERED IS '首播季度與年份 (如 Spring 2021)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.STATUS IS '播出狀態 (如 Finished Airing, Currently Airing)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.PRODUCERS IS '製作人/企劃公司 (逗號分隔)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.LICENSORS IS '版權代理商/授權平台 (逗號分隔)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.STUDIOS IS '動畫製作公司 (逗號分隔)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.SOURCE IS '原作來源 (如 Manga, Light Novel, Original)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.DURATION IS '單集播映時間';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.RATING IS '家長分級 (如 PG-13, R - 17+)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.RANK IS '評分排名';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.POPULARITY IS '人氣排名 (以成員數計算)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.FAVORITES IS '被收藏為最愛的人數';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.SCORED_BY IS '參與評分的使用者總數';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.MEMBERS IS '將此動畫加入清單的使用者總數 (成員數)';
    COMMENT ON COLUMN POLLO.ANIME_DATASET_2023.IMAGE_URL IS '動畫封面海報連結';
    
    -- =========================================================================
    -- 2. POLLO.ANIME_FILTERED (經過篩選的動畫元數據表)
    -- =========================================================================
    COMMENT ON TABLE POLLO.ANIME_FILTERED IS '經過篩選與清洗後的動畫元數據表 (候選集)';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.ANIME_ID IS '動畫唯一識別 ID (主鍵)';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.NAME IS '動畫名稱';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.SCORE IS '動畫平均評分 (1-10)';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.GENRES IS '動畫類型/風格 (逗號分隔)';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.ENGLISH_NAME IS '動畫英文名稱';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.JAPANESE_NAME IS '動畫日文原名';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.SYPNOPSIS IS '動畫劇情簡介 (欄位拼寫為 SYPNOPSIS)';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.TYPE IS '動畫類型 (如 TV, Movie, OVA)';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.EPISODES IS '總集數';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.AIRED IS '播出日期範圍描述';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.PREMIERED IS '首播季度與年份';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.PRODUCERS IS '製作人/企劃公司';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.LICENSORS IS '版權代理商/授權平台';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.STUDIOS IS '動畫製作公司';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.SOURCE IS '原作來源';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.DURATION IS '單集播映時間';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.RATING IS '家長分級';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.RANKED IS '評分排名 (欄位拼寫為 RANKED)';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.POPULARITY IS '人氣排名';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.MEMBERS IS '將此動畫加入清單的使用者總數';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.FAVORITES IS '被收藏為最愛的人數';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.WATCHING IS '目前正在觀看的人數';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.COMPLETED IS '已經看完的人數';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.ON_HOLD IS '暫停觀看的人數';
    COMMENT ON COLUMN POLLO.ANIME_FILTERED.DROPPED IS '已棄追的人數';
    
    -- =========================================================================
    -- 3. POLLO.USERS_DETAILS_2023 (使用者帳號詳細資訊表)
    -- =========================================================================
    COMMENT ON TABLE POLLO.USERS_DETAILS_2023 IS '2023 年使用者帳號詳細資訊表 (使用者維度表)';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.MAL_ID IS '使用者唯一識別 ID (主鍵)';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.USERNAME IS '使用者帳號名稱 (唯一值)';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.GENDER IS '性別 (如 Male, Female, Non-Binary 等)';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.BIRTHDAY IS '生日 (ISO 格式/字串)';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.LOCATION IS '居住地或國家';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.JOINED IS '加入 MyAnimeList 平台日期 (ISO 格式/字串)';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.DAYS_WATCHED IS '總計觀看動漫天數 (時長累計)';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.MEAN_SCORE IS '該使用者給出的平均分數';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.WATCHING IS '目前正在觀看的動畫數量';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.COMPLETED IS '已看完的動畫數量';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.ON_HOLD IS '暫停觀看的動畫數量';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.DROPPED IS '已棄追的動畫數量';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.PLAN_TO_WATCH IS '計畫觀看的動畫數量';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.TOTAL_ENTRIES IS '清單中的動漫總數量';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.REWATCHED IS '重複觀看的動畫數量';
    COMMENT ON COLUMN POLLO.USERS_DETAILS_2023.EPISODES_WATCHED IS '累計觀看的動畫集數';
    
    -- =========================================================================
    -- 4. POLLO.USERS_SCORE_2023 (使用者評分事實表 - 顯式評分)
    -- =========================================================================
    COMMENT ON TABLE POLLO.USERS_SCORE_2023 IS '2023 年使用者評分事實表 (僅限顯式評分 1-10 分)';
    COMMENT ON COLUMN POLLO.USERS_SCORE_2023.USER_ID IS '使用者 ID (外鍵)';
    COMMENT ON COLUMN POLLO.USERS_SCORE_2023.USERNAME IS '使用者帳號名稱';
    COMMENT ON COLUMN POLLO.USERS_SCORE_2023.ANIME_ID IS '動畫 ID (外鍵)';
    COMMENT ON COLUMN POLLO.USERS_SCORE_2023.ANIME_TITLE IS '動畫標題';
    COMMENT ON COLUMN POLLO.USERS_SCORE_2023.RATING IS '使用者給出的評分 (1-10)';
    
    -- =========================================================================
    -- 5. POLLO.USER_FILTERED (經過篩選的評分行為事實表)
    -- =========================================================================
    COMMENT ON TABLE POLLO.USER_FILTERED IS '經過過濾的使用者評分行為表 (包含評分 0 代表未評分/計畫觀看等隱式行為)';
    COMMENT ON COLUMN POLLO.USER_FILTERED.USER_ID IS '使用者 ID (外鍵)';
    COMMENT ON COLUMN POLLO.USER_FILTERED.ANIME_ID IS '動畫 ID (外鍵)';
    COMMENT ON COLUMN POLLO.USER_FILTERED.RATING IS '使用者評分 (0 代表未評分，1-10 代表已評分)';
    
    -- =========================================================================
    -- 6. POLLO.FINAL_ANIMEDATASET (反正規化評分分析寬表)
    -- =========================================================================
    COMMENT ON TABLE POLLO.FINAL_ANIMEDATASET IS '反正規化動畫評分分析寬表 (已合併使用者細節與動畫屬性)';
    COMMENT ON COLUMN POLLO.FINAL_ANIMEDATASET.USERNAME IS '使用者帳號名稱';
    COMMENT ON COLUMN POLLO.FINAL_ANIMEDATASET.ANIME_ID IS '動畫 ID (外鍵)';
    COMMENT ON COLUMN POLLO.FINAL_ANIMEDATASET.MY_SCORE IS '使用者給出的評分 (0-10，0代表未評分)';
    COMMENT ON COLUMN POLLO.FINAL_ANIMEDATASET.USER_ID IS '使用者 ID (外鍵)';
    COMMENT ON COLUMN POLLO.FINAL_ANIMEDATASET.GENDER IS '使用者性別 (無 NULL 值)';
    COMMENT ON COLUMN POLLO.FINAL_ANIMEDATASET.TITLE IS '動畫標題';
    COMMENT ON COLUMN POLLO.FINAL_ANIMEDATASET.TYPE IS '動畫類型';
    COMMENT ON COLUMN POLLO.FINAL_ANIMEDATASET.SOURCE IS '原作來源';
    COMMENT ON COLUMN POLLO.FINAL_ANIMEDATASET.SCORE IS '動畫平台平均評分';
    COMMENT ON COLUMN POLLO.FINAL_ANIMEDATASET.SCORED_BY IS '動畫平台評分人數';
    COMMENT ON COLUMN POLLO.FINAL_ANIMEDATASET.RANK IS '動畫平台評分排名';
    COMMENT ON COLUMN POLLO.FINAL_ANIMEDATASET.POPULARITY IS '動畫平台人氣排名';
    COMMENT ON COLUMN POLLO.FINAL_ANIMEDATASET.GENRE IS '動畫風格類型 (逗號分隔)';

    -- =========================================================================
    -- 7. POLLO.GOV_DATASET_REGISTRY (政府開放資料集註冊中介資料表)
    -- =========================================================================
    COMMENT ON TABLE POLLO.GOV_DATASET_REGISTRY IS '政府開放資料集註冊中介資料表';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.OBJID IS '紀錄唯一識別碼 (主鍵)';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.DATASET_ID IS '開放資料集 ID';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.DATASET_NAME IS '資料集名稱';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.DATA_PROVIDER_ATTR IS '資料提供者屬性定義';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.SERVICE_CATEGORY IS '服務分類';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.QUALITY_CHECK IS '品質檢驗狀態描述';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.FILE_FORMAT IS '資料檔案格式 (如 CSV, XML)';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.DOWNLOAD_URL IS '資料下載 URL 網址';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.ENCODING_FORMAT IS '字元編碼格式 (如 UTF-8)';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.PUBLISH_METHOD IS '發布方式描述';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.DATASET_DESC IS '資料集詳細說明描述';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.MAIN_FIELDS IS '主要欄位說明描述';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.PROVIDER_AGENCY IS '資料提供機關名稱';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.UPDATE_FREQUENCY IS '資料更新頻率';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.LICENSE_TYPE IS '授權類型說明';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.RELATED_URL IS '相關連結網址';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.BILLING_TYPE IS '計費方式 (如免費)';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.CONTACT_NAME IS '業務聯絡人姓名';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.CONTACT_PHONE IS '業務聯絡人電話';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.PUBLISH_DATE IS '發布日期';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.METADATA_UPDATE_TIME IS '中介資料更新時間';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.REMARKS IS '備註欄位';
    COMMENT ON COLUMN POLLO.GOV_DATASET_REGISTRY.DATA_VOLUME IS '資料量描述';