后台管理
数据库
只读浏览 kotoba
字段
18 个
| 字段名 | 类型 | 可空 | 键 | 默认值 | 附加 | 中文说明 |
|---|---|---|---|---|---|---|
id |
smallint unsigned |
否 | PRI | — | auto_increment | 数据库内部数字主键 |
title |
varchar(255) |
否 | UNI | — | — | Section 原标题 |
section_key |
char(7) |
否 | UNI | — | — | Section 永久编号 |
chapter |
tinyint unsigned |
否 | — | — | — | 所属章节编号 |
section_no |
tinyint unsigned |
否 | — | — | — | 章内 Section 编号 |
start_no |
smallint unsigned |
否 | — | — | — | 起始原始条目编号 |
end_no |
smallint unsigned |
否 | — | — | — | 结束原始条目编号 |
item_count |
smallint unsigned |
否 | — | — | — | 原始条目数量 |
pdf_start_page |
smallint unsigned |
否 | — | — | — | PDF 起始页 |
book_start_page |
smallint unsigned |
否 | — | — | — | 原书起始页 |
chapter_name_en |
varchar(255) |
否 | — | — | — | 章节英文名 |
chapter_name_jp |
varchar(255) |
否 | — | — | — | 章节日文名 |
section_name_en |
varchar(255) |
否 | — | — | — | Section 英文名 |
section_name_jp |
varchar(255) |
否 | — | — | — | Section 日文名 |
verified |
tinyint(1) |
否 | — | — | — | 是否已复核 |
source_entry_ids |
json |
否 | — | — | — | 关联 n5_source_entries.id 数组 |
created_at |
datetime(6) |
否 | — |
CURRENT_TIMESTAMP(6)
|
DEFAULT_GENERATED | 创建时间（UTC） |
updated_at |
datetime(6) |
否 | — |
CURRENT_TIMESTAMP(6)
|
DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6) | 最后更新时间（UTC） |
数据
共 50 行，每页 50 行
查看 CRUD API
id |
title |
section_key |
chapter |
section_no |
start_no |
end_no |
item_count |
pdf_start_page |
book_start_page |
chapter_name_en |
chapter_name_jp |
section_name_en |
section_name_jp |
verified |
source_entry_ids |
created_at |
updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50 | C10-S05｜これも おぼえよう！ | C10-S05 | 10 | 5 | 1018 | 1046 | 29 | 161 | 166 | Health etc. | けんこう etc. | Let's remember this! | これも おぼえよう！ | 1 | [1015,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046] | 2026-07-26 02:46:05.870176 | 2026-07-26 02:46:05.870176 |
| 49 | C10-S04｜しょうらい | C10-S04 | 10 | 4 | 1002 | 1017 | 16 | 159 | 164 | Health etc. | けんこう etc. | Future | しょうらい | 1 | [916,924,926,933,938,959,965,974,976,991,998,1003,1014,1016,1017,1032] | 2026-07-26 02:46:05.850752 | 2026-07-26 02:46:05.850752 |
| 48 | C10-S03｜たいせつな もの・こと | C10-S03 | 10 | 3 | 986 | 1001 | 16 | 157 | 162 | Health etc. | けんこう etc. | Important Things | たいせつな もの・こと | 1 | [927,936,947,949,953,958,961,964,975,977,979,982,996,999,1001,1009] | 2026-07-26 02:46:05.831514 | 2026-07-26 02:46:05.831514 |
| 47 | C10-S02｜お元気ですか。 | C10-S02 | 10 | 2 | 965 | 985 | 21 | 154 | 159 | Health etc. | けんこう etc. | How are you? | お元気ですか。 | 1 | [915,918,921,923,928,929,941,943,946,955,968,971,973,983,986,993,997,1004,1005,1006,1010] | 2026-07-26 02:46:05.812344 | 2026-07-26 02:46:05.812344 |
| 46 | C10-S01｜びょうき | C10-S01 | 10 | 1 | 943 | 964 | 22 | 151 | 156 | Health etc. | けんこう etc. | Sick | びょうき | 1 | [919,920,922,932,935,942,945,951,956,957,960,963,969,970,980,987,992,1002,1007,1008,1011,1012] | 2026-07-26 02:46:05.792767 | 2026-07-26 02:46:05.792767 |
| 45 | C09-S05｜電気 | C09-S05 | 9 | 5 | 925 | 942 | 18 | 147 | 152 | Living | すむ | Electricity | 電気 | 1 | [917,925,931,934,939,940,944,948,950,962,967,984,985,989,990,994,995,1013] | 2026-07-26 02:46:05.770839 | 2026-07-26 02:46:05.770839 |
| 44 | C09-S04｜先生のいえ | C09-S04 | 9 | 4 | 893 | 924 | 32 | 142 | 147 | Living | すむ | Teacher's House | 先生のいえ | 1 | [817,820,825,829,832,834,840,842,843,844,846,863,865,868,873,880,884,893,896,898,902,911,930,937,952,954,966,972,978,981,988,1000] | 2026-07-26 02:46:05.751956 | 2026-07-26 02:46:05.751956 |
| 43 | C09-S03｜ひっこし | C09-S03 | 9 | 3 | 873 | 892 | 20 | 139 | 144 | Living | すむ | Moving | ひっこし | 1 | [818,822,835,836,839,845,851,854,866,877,883,885,890,891,895,897,899,900,901,910] | 2026-07-26 02:46:05.737135 | 2026-07-26 02:46:05.737135 |
| 42 | C09-S02｜アパートの 2かい | C09-S02 | 9 | 2 | 863 | 872 | 10 | 137 | 142 | Living | すむ | Second Floor of the Apartment | アパートの 2かい | 1 | [826,827,847,853,856,857,861,864,874,878] | 2026-07-26 02:46:05.719505 | 2026-07-26 02:46:05.719505 |
| 41 | C09-S01｜いえ | C09-S01 | 9 | 1 | 836 | 862 | 27 | 133 | 138 | Living | すむ | House | いえ | 1 | [815,823,830,837,838,841,848,855,858,859,869,870,871,875,876,881,886,887,888,892,894,904,906,908,909,912,914] | 2026-07-26 02:46:05.700297 | 2026-07-26 02:46:05.700297 |
| 40 | C08-S05｜出かける | C08-S05 | 8 | 5 | 811 | 835 | 25 | 128 | 133 | Holiday | 休みの日 | Go Out | 出かける | 1 | [724,749,761,808,816,819,821,824,828,831,833,849,850,852,860,862,867,872,879,882,889,903,905,907,913] | 2026-07-26 02:46:05.681902 | 2026-07-26 02:46:05.681902 |
| 39 | C08-S04｜どこ？ | C08-S04 | 8 | 4 | 798 | 810 | 13 | 126 | 131 | Holiday | 休みの日 | Where? | どこ？ | 1 | [715,723,746,752,766,769,775,781,785,789,797,798,806] | 2026-07-26 02:46:05.662866 | 2026-07-26 02:46:05.662866 |
| 38 | C08-S03｜みち | C08-S03 | 8 | 3 | 775 | 797 | 23 | 123 | 128 | Holiday | 休みの日 | Road | みち | 1 | [717,718,726,727,729,735,737,740,741,742,744,748,754,758,772,773,788,790,796,799,800,801,810] | 2026-07-26 02:46:05.645319 | 2026-07-26 02:46:05.645319 |
| 37 | C08-S02｜どのくらい？ | C08-S02 | 8 | 2 | 763 | 774 | 12 | 121 | 126 | Holiday | 休みの日 | How long? | どのくらい？ | 1 | [725,728,731,734,757,760,768,786,804,805,807,814] | 2026-07-26 02:46:05.627581 | 2026-07-26 02:46:05.627581 |
| 36 | C08-S01｜のりもの | C08-S01 | 8 | 1 | 734 | 762 | 29 | 117 | 122 | Holiday | 休みの日 | Rides | のりもの | 1 | [716,720,721,722,732,738,739,745,747,750,751,753,755,759,763,765,767,770,777,780,787,791,792,794,802,803,809,811,812] | 2026-07-26 02:46:05.608604 | 2026-07-26 02:46:05.608604 |
| 35 | C07-S05｜プレゼント | C07-S05 | 7 | 5 | 714 | 733 | 20 | 111 | 116 | Shopping | 買い物 | Present | プレゼント | 1 | [673,719,730,733,736,743,756,762,764,771,774,776,778,779,782,783,784,793,795,813] | 2026-07-26 02:46:05.592383 | 2026-07-26 02:46:05.592383 |
| 34 | C07-S04｜おくる | C07-S04 | 7 | 4 | 696 | 713 | 18 | 108 | 113 | Shopping | 買い物 | Send | おくる | 1 | [617,623,629,630,633,643,649,658,659,660,670,678,681,685,690,693,705,708] | 2026-07-26 02:46:05.576490 | 2026-07-26 02:46:05.576490 |
| 33 | C07-S03｜ATM | C07-S03 | 7 | 3 | 680 | 695 | 16 | 106 | 111 | Shopping | 買い物 | ATM | ATM | 1 | [625,637,648,651,657,664,672,679,682,686,696,699,700,703,710,713] | 2026-07-26 02:46:05.557062 | 2026-07-26 02:46:05.557062 |
| 32 | C07-S02｜みせ | C07-S02 | 7 | 2 | 660 | 679 | 20 | 103 | 108 | Shopping | 買い物 | Shop | みせ | 1 | [620,624,627,641,645,647,650,652,662,666,667,668,671,675,684,691,698,701,704,712] | 2026-07-26 02:46:05.536805 | 2026-07-26 02:46:05.536805 |
| 31 | C07-S01｜買い物 | C07-S01 | 7 | 1 | 635 | 659 | 25 | 99 | 104 | Shopping | 買い物 | Shopping | 買い物 | 1 | [619,622,631,632,635,636,639,642,646,653,654,655,661,663,665,674,676,680,683,687,692,707,709,711,714] | 2026-07-26 02:46:05.517628 | 2026-07-26 02:46:05.517628 |
| 30 | C06-S05｜きせつ | C06-S05 | 6 | 5 | 608 | 634 | 27 | 93 | 98 | Hobby | しゅみ | Season | きせつ | 1 | [559,572,574,591,598,599,606,615,616,618,621,626,628,634,638,640,644,656,669,677,688,689,694,695,697,702,706] | 2026-07-26 02:46:05.496858 | 2026-07-26 02:46:05.496858 |
| 29 | C06-S04｜てんき | C06-S04 | 6 | 4 | 588 | 607 | 20 | 90 | 95 | Hobby | しゅみ | Weather | てんき | 1 | [515,523,526,528,533,536,537,538,540,551,558,562,568,586,587,590,596,597,604,605] | 2026-07-26 02:46:05.477473 | 2026-07-26 02:46:05.477473 |
| 28 | C06-S03｜スポーツ | C06-S03 | 6 | 3 | 566 | 587 | 22 | 87 | 92 | Hobby | しゅみ | Sports | スポーツ | 1 | [520,524,531,539,541,543,544,545,549,550,557,569,570,571,577,581,592,593,600,608,610,613] | 2026-07-26 02:46:05.458234 | 2026-07-26 02:46:05.458234 |
| 27 | C06-S02｜おんがく | C06-S02 | 6 | 2 | 543 | 565 | 23 | 84 | 89 | Hobby | しゅみ | Music | おんがく | 1 | [516,517,519,521,529,535,547,548,552,553,556,561,565,566,573,580,585,589,595,601,602,611,614] | 2026-07-26 02:46:05.438797 | 2026-07-26 02:46:05.438797 |
| 26 | C06-S01｜しゅみ | C06-S01 | 6 | 1 | 519 | 542 | 24 | 81 | 86 | Hobby | しゅみ | Hobby | しゅみ | 1 | [522,525,527,530,532,534,542,554,555,560,567,575,576,578,579,582,583,584,588,594,603,607,609,612] | 2026-07-26 02:46:05.424564 | 2026-07-26 02:46:05.424564 |
| 25 | C05-S05｜どうですか。 | C05-S05 | 5 | 5 | 504 | 518 | 15 | 78 | 83 | Today's Meal | きょうの ごはん | How is it? | どうですか。 | 1 | [458,471,472,476,480,491,493,494,499,503,507,518,546,563,564] | 2026-07-26 02:46:05.406985 | 2026-07-26 02:46:05.406985 |
| 24 | C05-S04｜レストラン | C05-S04 | 5 | 4 | 483 | 503 | 21 | 75 | 80 | Today's Meal | きょうの ごはん | Restaurant | レストラン | 1 | [417,419,427,439,443,450,455,456,459,461,462,470,473,484,486,496,497,508,511,513,514] | 2026-07-26 02:46:05.387959 | 2026-07-26 02:46:05.387959 |
| 23 | C05-S03｜りょうり | C05-S03 | 5 | 3 | 460 | 482 | 23 | 72 | 77 | Today's Meal | きょうの ごはん | Cooking | りょうり | 1 | [415,418,422,426,429,430,431,436,437,441,449,451,453,463,464,467,469,474,477,489,495,500,501] | 2026-07-26 02:46:05.368288 | 2026-07-26 02:46:05.368288 |
| 22 | C05-S02｜食べる・飲む | C05-S02 | 5 | 2 | 419 | 459 | 41 | 68 | 73 | Today's Meal | きょうの ごはん | Eat, Drink | 食べる・飲む | 1 | [416,420,421,423,424,425,428,433,435,438,440,442,444,445,446,447,448,452,454,457,460,465,466,468,475,478,479,481,482,483,485,487,488,490,492,498,502,504,505,510,512] | 2026-07-26 02:46:05.349146 | 2026-07-26 02:46:05.349146 |
| 21 | C05-S01｜あさ・よる | C05-S01 | 5 | 1 | 394 | 418 | 25 | 65 | 70 | Today's Meal | きょうの ごはん | Morning, Evening | あさ・よる | 1 | [316,319,320,322,323,326,328,337,343,345,347,349,356,361,377,386,388,391,394,402,406,432,434,506,509] | 2026-07-26 02:46:05.329987 | 2026-07-26 02:46:05.329987 |
| 20 | C04-S05｜町 | C04-S05 | 4 | 5 | 366 | 393 | 28 | 62 | 67 | Friend | 友だち | Town | 町 | 1 | [329,341,346,354,355,357,358,359,362,363,364,365,366,367,368,373,374,383,385,387,393,398,399,403,404,408,409,410] | 2026-07-26 02:46:05.315957 | 2026-07-26 02:46:05.315957 |
| 19 | C04-S04｜あそぶ | C04-S04 | 4 | 4 | 344 | 365 | 22 | 59 | 64 | Friend | 友だち | Play | あそぶ | 1 | [317,318,325,327,330,336,338,339,342,353,360,369,371,372,381,384,389,395,401,407,412,413] | 2026-07-26 02:46:05.297929 | 2026-07-26 02:46:05.297929 |
| 18 | C04-S03｜スカートを はきます。 | C04-S03 | 4 | 3 | 325 | 343 | 19 | 56 | 61 | Friend | 友だち | I wear a skirt. | スカートを はきます。 | 1 | [315,321,324,331,334,335,340,344,348,351,370,375,378,380,382,390,392,400,414] | 2026-07-26 02:46:05.279631 | 2026-07-26 02:46:05.279631 |
| 17 | C04-S02｜シャツを きています。 | C04-S02 | 4 | 2 | 306 | 324 | 19 | 54 | 59 | Friend | 友だち | I am wearing a shirt. | シャツを きています。 | 1 | [221,222,241,248,253,282,283,301,310,332,333,350,352,376,379,396,397,405,411] | 2026-07-26 02:46:05.260517 | 2026-07-26 02:46:05.260517 |
| 16 | C04-S01｜どんな 人？ | C04-S01 | 4 | 1 | 284 | 305 | 22 | 51 | 56 | Friend | 友だち | What kind of person? | どんな 人？ | 1 | [217,227,229,231,239,242,243,249,251,254,257,258,266,270,271,272,278,280,293,298,311,312] | 2026-07-26 02:46:05.241857 | 2026-07-26 02:46:05.241857 |
| 15 | C03-S05｜時間 | C03-S05 | 3 | 5 | 270 | 283 | 14 | 45 | 50 | Work | しごと | Time | 時間 | 1 | [219,226,230,232,247,255,261,265,268,273,284,287,304,314] | 2026-07-26 02:46:05.223530 | 2026-07-26 02:46:05.223530 |
| 14 | C03-S04｜何こ ありますか。 | C03-S04 | 3 | 4 | 266 | 269 | 4 | 43 | 48 | Work | しごと | How many is there? | 何こ ありますか。 | 1 | [225,260,286,296] | 2026-07-26 02:46:05.205920 | 2026-07-26 02:46:05.205920 |
| 13 | C03-S03｜これは何ですか。 | C03-S03 | 3 | 3 | 235 | 265 | 31 | 38 | 43 | Work | しごと | What is this? | これは何ですか。 | 1 | [215,218,223,228,233,234,235,236,237,240,245,250,256,262,263,264,267,269,274,275,276,277,285,290,294,297,299,300,305,307,313] | 2026-07-26 02:46:05.192405 | 2026-07-26 02:46:05.192405 |
| 12 | C03-S02｜しごと | C03-S02 | 3 | 2 | 222 | 234 | 13 | 36 | 41 | Work | しごと | Work | しごと | 1 | [244,246,259,279,289,291,292,295,302,303,306,308,309] | 2026-07-26 02:46:05.174050 | 2026-07-26 02:46:05.174050 |
| 11 | C03-S01｜はたらく | C03-S01 | 3 | 1 | 197 | 221 | 25 | 33 | 38 | Work | しごと | to Work | はたらく | 1 | [116,150,155,156,158,164,169,177,180,185,194,200,202,206,209,211,213,214,216,220,224,238,252,281,288] | 2026-07-26 02:46:05.156326 | 2026-07-26 02:46:05.156326 |
| 10 | C02-S05｜べんきょう | C02-S05 | 2 | 5 | 172 | 196 | 25 | 29 | 34 | Study | べんきょう | Study | べんきょう | 1 | [120,121,125,127,130,142,143,152,153,154,163,167,168,173,178,181,183,186,187,191,193,195,196,199,203] | 2026-07-26 02:46:05.138806 | 2026-07-26 02:46:05.138806 |
| 9 | C02-S04｜ことば | C02-S04 | 2 | 4 | 153 | 171 | 19 | 27 | 32 | Study | べんきょう | Words | ことば | 1 | [115,119,123,124,126,128,133,136,139,151,157,159,166,174,188,198,201,205,210] | 2026-07-26 02:46:05.121215 | 2026-07-26 02:46:05.121215 |
| 8 | C02-S03｜よう日 | C02-S03 | 2 | 3 | 133 | 152 | 20 | 25 | 30 | Study | べんきょう | Day of the Week | よう日 | 1 | [117,118,122,129,131,132,134,137,138,144,145,148,149,172,175,179,182,189,207,208] | 2026-07-26 02:46:05.102041 | 2026-07-26 02:46:05.102041 |
| 7 | C02-S02｜かず | C02-S02 | 2 | 2 | 118 | 132 | 15 | 23 | 28 | Study | べんきょう | Number | かず | 1 | [135,140,141,146,147,160,161,165,170,176,184,190,192,204,212] | 2026-07-26 02:46:05.082139 | 2026-07-26 02:46:05.082139 |
| 6 | C02-S01｜学校 | C02-S01 | 2 | 1 | 103 | 117 | 15 | 21 | 26 | Study | べんきょう | School | 学校 | 1 | [37,45,49,52,54,58,62,64,70,73,89,99,162,171,197] | 2026-07-26 02:46:05.067458 | 2026-07-26 02:46:05.067458 |
| 5 | C01-S05｜～から きました | C01-S05 | 1 | 5 | 68 | 102 | 35 | 17 | 22 | Self Introduction | じこしょうかい | Came from ~ | ～から きました | 1 | [15,16,17,18,20,21,25,27,28,29,34,42,43,50,51,53,55,57,65,66,71,72,76,79,83,87,88,90,91,95,96,103,108,113,114] | 2026-07-26 02:46:05.049225 | 2026-07-26 02:46:05.049225 |
| 4 | C01-S04｜なんにんですか。 | C01-S04 | 1 | 4 | 51 | 67 | 17 | 15 | 20 | Self Introduction | じこしょうかい | How many people? | なんにんですか。 | 1 | [19,23,40,44,47,48,75,78,80,82,84,86,92,98,101,102,104] | 2026-07-26 02:46:05.029295 | 2026-07-26 02:46:05.029295 |
| 3 | C01-S03｜かぞく | C01-S03 | 1 | 3 | 29 | 50 | 22 | 13 | 18 | Self Introduction | じこしょうかい | Family | かぞく | 1 | [24,30,32,33,39,41,46,56,59,60,61,63,69,74,85,93,94,97,100,105,106,110] | 2026-07-26 02:46:05.011172 | 2026-07-26 02:46:05.011172 |
| 2 | C01-S02｜おはよう。 | C01-S02 | 1 | 2 | 14 | 28 | 15 | 9 | 14 | Self Introduction | じこしょうかい | Good morning. | おはよう。 | 1 | [14,22,26,31,35,36,38,67,68,77,81,107,109,111,112] | 2026-07-26 02:46:04.992577 | 2026-07-26 02:46:04.992577 |
| 1 | C01-S01｜～です | C01-S01 | 1 | 1 | 1 | 13 | 13 | 7 | 12 | Self Introduction | じこしょうかい | ~ is | ～です | 1 | [1,2,3,4,5,6,7,8,9,10,11,12,13] | 2026-07-26 02:46:04.976049 | 2026-07-26 02:46:04.976049 |