TFT/LCD驱动IC NT35510芯片手册datasheet
TFT/LCD驱动IC、手机显示屏驱动IC-NT35510,文档详细讲解了该芯片的接口定义,以及驱动显示屏的解决方案.NOVATEKPRELIMINARYNT355105.4.2 MDD/ Link Packet Descriptions by the NT355101625.4.3 Writing Video Data to Memory Sequence.......1725.44 Writing Register Sequence...….…,…1725.4.5 Reading video Data from Memory Sequence.7735.4.6 Reading Register Sequence………,…,…,…,…,…,…,…,…,…,…,…,…,…,…,…,…,………735.4.7 Hibernation Setting-..,.,…,…T745.4.8 MDD/ Deep Standby Mode Setting-……,……,…,…,…,…,…,…,………,…,…1755.5 INTERFACE PAUSE1775. 6 DATA TRANSFER BREAK AND RECOVERY.1785.7 DISPLAY MODULE DATA TRANSFER MODES,58RGB| NTERFACE,,nn,,…,…,,,……18158.1 Genera/ Description.…,.,.,…,…1815.8.2 RGB Interface Timing Chart1825.8.3 RGB Interface Mode Set.1835.8.4 RGB Interface Bus Width Set.18759 FRAME MEMORY,……,,,191591 Configuration…....…n1915.92 Address Counter….……………,7925.9.3 Interface to Memory Write Direction.........1935.9.4 Frame Memory to Display Address Mapping.......n…1945.10 TEARING EFFECT INFORMATION1955.10.1 Tearing Effect Output Line1955.10.2 Tearing Effect Bus Trigger..........面面面面面面面aa面面看日自DB自2005.11 CHECKSUM2125.12 POWER ON/OFF SEQUENCE2145. 12. 1 Case 1-REsX line is held High or Unstable by Host at Power On..................2155. 12.2 Case 2- ResX line is held Low by host at power on...e.2165.12.3 Uncontrolled power off2765.13 PoWER LEVEL MODES wmmmmmm2175.13.1 Definition2175.13.2 Power level Mode flow chartn2185.14 RESET FUNCTION…112205.14. 1 Register Default value2205.14.2 Output or Bi- directiona/{o)Pins………,,,…,……………,…,…,,…,…………,……,………2225.14.3 Input Pins………,…,,…,…2221028/20113Version o 8With respect to the information represented in this document, Novatek makes no warranty, expressed or implied, including the warranties of merchantabilityfitness for a particular purpose, non-infringement, or assumes any legal liability or responsibility for the accuracy, completeness, or usefulness of any suchinformationNOVATEKPRELIMINARYNT355105.15 SLEEP OUT-COMMAND AND SELF-DIAGNOSTIC FUNCTIONS OF THE DISPLAY MODULE2235. 15. 1 Register loading Detection.....2235.15.2 Functionality Detection2245.15.3 Chip Attachment Detection…….2255.16 DISPLAY PANEL COLOR CHARACTERISTICS mmmm 2265.17 GAMMA FUNCTI0N..…,………面国面面面国面2275.18 BASIC DISPLAY MODE■日量2285.19 NSTRUCTION SETTING SEQUENCE2295.19.1 Sleep In/Out Sequence…,…,…,…,…,…,…,…,…,…,,…,…,…,…,,…2295192 Deep Standby Mode Enter/ Exit Sequence……2305.20 INSTRUCTION SETUP FLOW2315. 20.1 Initializing with the Built-in Power Supply circuits2315. 20.2 Power OFF Sequence232521 MTP WRITE SEQUENCE…….2335.22 DYNAMIC BACKLIGHT CONTROL FUNCTION234522.1 PWM Control Architecture面面面面面面a面a面面2365. 22.2 Dimming Function for LABC and Manual Brightness Control6.22. 3 Dimming Function for CABC and Force PWM Function,2445.22.4 PWM Signal Setting for CABC and LABC2455.2.5 Content Adaptive Brightness Contro/CABC)………,2475.22.6 Ambient Light Sensor and Automatic Brightness Contro(LABC)…,…,…,…,…,…,…,…,…,………2485.23 COLUMN, 1-DOT, 2-DOT, 3-DOT AND 4-DOT INVERSION (VCOM DC DRIVE2556 COMMAND DESCRIPTIONS2566.1 USER COMMAND SET256NOP0000)....,.…260SWRESET: Software Reset (0100h ...267RDDID: Read Display ID(0400h-0402h)262RDNUMED: Read Number of Errors onRDDPM: Read Display Power Mode(0A00h)............264RDDMADCT: Read Display MAdo间0B0oh),…,265RDDCOLMOD: Read Display Pixel Format0cooh)………266RDDM: Read Display image Mode间 0D00h)……,…………………………………………………………267RDDSM: Read Display signa/Mode(0E00h)……................,…………………268RDDSDR: Read Display Self-Diagnostic Result(sLPN: Sleep In(1000h)-……2701028/20114Version o 8With respect to the information represented in this document, Novatek makes no warranty, expressed or implied, including the warranties of merchantabilityfitness for a particular purpose, non-infringement, or assumes any legal liability or responsibility for the accuracy, completeness, or usefulness of any suchinformationNOVATEKPRELIMINARYNT35510SLPOUT: Sleep Out(100h)……,…,…,…,…,…,…,…,…,……272PTLON: Partial Display Mode On(1200h).........274NORON: Norma| Display Mode On(1300h)...............………275INVOFF: Display Inversion Off (2000h)276yvoN: Display Inversion On(2100b)….......……量道量道面道量温量量量面量面面面面目面面277ALLPOFF: All Pixel Off(2200h)278ALLPON: All Pixel On(2300h280GAMSET: Gamma Set(2600h)…,,,,,,…,282DISPOFF: Display ofi(2800b)….……....,,…,…,…,…,……,283DISPON: Display On( 2900b)284CASET: Column address set(2A00h~2A03h).……,,…285RASET: Row Address Setn287RAMWR: Memory Write(2c00h)289RAMRD: Memory290PILAR: Partial Area(3000h-3003)....∴291TEOFF: Tearing Effect Line OFF (3400h)面面面面面a面面294TEON: Tearing Effect Line ON (3500h)295MADCTL: Memory data Access Control (3600h)..............................296DMOFF: dle mode o(3800……299IDMON: ldle Mode On (3900h).......300COLMOD: Interface Pixel Format 3A00h)302RAMWRC: Memory Write Continue(3c00h)…..........……303RAMRDC: Memory Read Continue(3E00h)……,…,,…,,,…,…304STESL: Set Tearing Effect Scan Line(4400h-4401)...........305GSL: Get Scan Line(4500h-4501h),.…,…,…,…,…,…,…,…,…,…,…,,…307DPCKRGB: Display Clock in RGB Interface(4A00h)308DSTBON: Deep Standby Mode On(4F00h)BIEaIESEBBSEBSEEEE309WRPFD: Write Profile value for Display (5000h-500Fh)........................310WRDISBV: Write Display Brightness(5100h)...………311RDDISBV: Read Display Brightness(5200h)…,…312WRCTRLD: Write CTRL Display(5300h)………313RDCTRLD: Read CTRL Display value(5400h)……,.....,…....……,…,…………315WRCABO: Write Content Adaptive Brightness Contro(5500h)…………………317RDCABO: Read Content Adaptive Brightness Control(5600h)…….…,…,…,…,…,……,…,…,……………………318NRHYSTE: Write3191028/20115Version o 8With respect to the information represented in this document, Novatek makes no warranty, expressed or implied, including the warranties of merchantabilityfitness for a particular purpose, non-infringement, or assumes any legal liability or responsibility for the accuracy, completeness, or usefulness of any suchinformationNOVATEKPRELIMINARYNT35510WRGAMMSET: Write Gamma Setting(5800h-5807h)..eec.321RDFSVM: Read Fs Value MSBs(5A00h)...........323RDFSVE: Read Fs value lsBs(5B0h)..............….……324RDMFFSVM Read Median Filter Fs value MSBs (cooh).325RDMFFSVL: Read Median Filter Fs value LSBs(5D00h)326WRCABCMB: Write CABC minimum brightness(5E00h).,…,…,…,………,,………327RDCABCMB: Read CABC minimum brightness(5Fooh).........328WRLSCO: Write Light Sensor Compensation Coefficient value(6500h~6501h)………,……………,…,…,…………329RDLSCCM: Read Light Sensor Compensation Coefficient Value MSBs(6600h )......,.........-. 330RDLSCCL: Read Light Sensor Compensation Coefficient Value LSBsRDBWLB: Read Black/White low Bits(7000h)332RDBkX: Read Bkx (7100h)333RDBky: Read Bky(7200h)334RDWX: Read Wx( 7300b)............. e..335RDWy: Read wy(7400h)…336RDRGLB: Read Red/Green Low Bits(7500h).......337RDRx: Read Rx(7600).……338RDRy: Read Ry(7700b)..........339RDGX: Read…,,,,,,,,340RDGy: Read Gy(7900h)....................n…341RDBALE: Read blue/ color low Bits(7A00h)……n,,342RDBx: Read Bx(7B00b)-..……,,,343RDBy: Read By(7c00b),,,,.,.,.,.,.,.,.,...,.,.,.,.,.,.,.,…,…344RDAx: Read ax(7D0oh)………,…345RDAy: Read Ay(7E00h)……,…,…,…346RDDDBS: Read DDB Start(A100h-A104h347RDDDBC: Read DDB Continue(A800h-A804h)349RDFCS: Read first checksum(AA0oh)……351RDCCS: Read Continue Checksum(AF00h)-.…………352RDID1: Read iD1 value(DAooh).ee..353RDD2: Read D2 Value(DB0oh)……354RDD3: Read D3vaue( COoh)……………,……………,…………………,…3557 SPECIFICATIONS…3567.1 ABSOLUTE MAXIMUM RATINGS.3567.2 ESD PROTECTION LEVEL3561028/20116Version o 8With respect to the information represented in this document, Novatek makes no warranty, expressed or implied, including the warranties of merchantabilityfitness for a particular purpose, non-infringement, or assumes any legal liability or responsibility for the accuracy, completeness, or usefulness of any suchinformationNOVATEKPRELIMINARYNT355107. 3 LATCH-UP PROTECTION LEVEL3567.4 LIGHT SENSITIVITY3567. 5 DC CHARACTERISTICS3577.5.1 Basic characteristics.357752MP/ Characteristics35975.3 MDD/ Characteristics wwwwwww 3617.5. 4 Current Consumption in Standby Mode and DSTB Mode..3627.6 AC CHARACTERISTICS3637.6.1 Parallel Interface Characteristics (80-Series McU)36376.2 SerialInterface Characteristicsaaaassaaaaussuaaaaaaaaaaaaaaaaaaaa3647.6.3 12C Bus Timing Characteristics36576.4 RGB Interface Characteristics3667.6.5 MIP/DS/ Timing Characteristics3677.6.6 MDD/ Timing Characteristics........3717.6.7 Reset Input Timing3728 REFERENCE APPLICATIONS. G.…3738.1 MICROPROCESSOR INTERFACE3738. 2 CONNECTIONS WITH PANEL. m..n..37810/28/2011Version o 8With respect to the information represented in this document, Novatek makes no warranty, expressed or implied, including the warranties of merchantabilityfitness for a particular purpose, non-infringement, or assumes any legal liability or responsibility for the accuracy, completeness, or usefulness of any suchinformationNOVATEKPRELIMINARYNT35510REVISION HISTORYPrepareChecked ApprovedVersionContentsDatebyy0.00OriginalKevinn swDennis2010/02/12Page 9, remove 32ORGB X 480Page 10, Features, remove 32ORGB X 480 and mux descriptionVGHO VGLO for gate control signals, remove VDDIM/SSIMPage11, update power voltage rangePage 12, Block diagramPage 13 to 22Add: VDD DET, DIOPWR, PSWAP, DSWAP, VGHO, VGLO, VRGHVREFCP, CSP, CSN, LVGL, C61P, C61N, VRGH, VREF, GOUT.Remove: VDDIMSSIM. VDDELUpdate: MVDDL,VGL,VGH, Test pinsPage23, update IF tablePage 51 to 66: update SPl, M3=1 setting in figurePage 102, 103, change DSIM, DSiG bit Reg to OXB 100Page 115, 124 Add WrPFD 50h on tablePage201, modified to 480X864 memoryPage202, Remove 320x480Page204, update whole Frame memory tablePage 205, TE map to 480 lines, DOPCTR change to B100hPage207, tvdI TBDPage225, 226, update VDD in figurePage227, Modes to 7Page232, Sout update to Gout0.01Page235, Add chip attachment Detection sectionKevinSWDens2010/03/17Page237, update Gamma StructurePage255, 270, update FOSC, ExamplePage266, update KB CLEDPage272, Add inversion sectionPage273, 274, Power ArchitecturePage275, update DIOPWRVREFCP, VGMP1,VGLOPage276, update C61P/N, LVGL, VGLO, VRGH,VREFCP, DIOPWR,VGMP 1/2VGMNVGSPVGSNPage291, change name to RAMKPPage306 to 312, remove 320x 480 resolution settingPage337, 5400h Cmd add a andg bitPage385, Absolute Max Rating for MV Hv, remove VDDIMPage 386, VDDIM removePage387, Vdev value modifiedPage402, 403, Remove MVDDI in notePage406, Remove 320 X 480, update 360X640 Sout sequencePage 173 to 181, MDDI windowless packetPage377, 379, A1, A8 cmd updatePage387 to 396, VDDI to 3.3VPage362 to 37670h to 7Eh cmd default valuePage28, 29, 30, 40, 41, 42 MPU figure updatePage 12, 274 Block and power architecture update10/28/20118Version o 8With respect to the information represented in this document, Novatek makes no warranty, expressed or implied, including the warranties of merchantabilityfitness for a particular purpose, non-infringement, or assumes any legal liability or responsibility for the accuracy, completeness, or usefulness of any suchinformationNOVATEKPRELIMINARYNT35510Page 10, remove 36ORGB X 640, Add 480RGBx720Page 11, update GPo[3: 01pdate VGHO, VGLOge 13, update Block DiagramPage 18, update IM, GPO, VSEL, and EXB1TPage 20, update VGLO, LVGLPage 21, update VGLX,VGL REG, Remove CP6 P/NPage 23, update VDD BCPage 24, update ContACT1-4, VSSIDUMPage 25, update iF description tablePage 207, update Address CounterKevinDennis2010/0406Page 235, update Resolution DataPage 252, remove CLED VOLPage 271, remove KB CLED_ VOLPage 277, add 4 dot inversionPage 306, 308, 313, 326 resolution update, remove nHD, add 480X720Page 384, update absolute voltagePage 385, update DC specPage 386, update Note3, Note5Page 405. update resolutionPage 406. update Alignment Mark-Page10,11205,206,234,305307,312,325404, update resolutionPage 13, update Block diagramPage 17-24, update pin description(MDDI not support DSWAPUpdate TEIR, TE_L, DSTB SEL, RESX, VSEL VREF PWR 12C_SDAremove VDD BD, ENDIOVPagB104121ric data type 0x24Page 134, update eotP optionPage 175, update MDDI support typPage 176, 177, update sub frame header, link shut down packetSWDennis2010/05/18Page 179, 180, update skew calibration packet, client capability packetPage 184, update packet type is 20Page 209, 214, update tE off, output is low, tering effect bus triggerPage 241, update gamma to 10 bits settingPage 276, update 3-dots inversionPage 384 update VIH, VIL, VoH,VOLPage 388, update hibernation wake upPage 390, 392 update Note2-Remove pad chapter to application note10/28/20119Version o 8With respect to the information represented in this document, Novatek makes no warranty, expressed or implied, including the warranties of merchantabilityfitness for a particular purpose, non-infringement, or assumes any legal liability or responsibility for the accuracy, completeness, or usefulness of any suchinformationNOVATEKPRELIMINARYNT35510Page 14, update block diagram of RGBBPPage 16, update WRX/SCL/2C SCL, sDI/2C SDAPage 19-25, update IM3 pin description, RGBBP(remove 12C SA1)OSC Test description, KBBC to test pinPage 21, update VREF PWr descriptionPage 26, update IM tablePage 42-44, update MPU read scriptionPage 49-52, update SPl+RGB or SPl+MDDI description0.04Page 60, update 12C AddressKevinSWDen201007/27Page 181, 182, update 16 bit SPI pause descriptionPage 187-189, update RGB figurePage 200, update TE waveform in RGB mode 2Page 237, MTP sequencePage 238-258, update one dimming control for LABC CABcremove KBBc function descriptionPage 260, update 0X04 Cmd, remove KBBC CmdPage 262, update 0XA 1,0xA8 CmdRemove all the KBBc related function registerPage11,12,190,191,219,284-287,291,304,376,remove 480RGBX 360Page 15, update MTP PWR application voltagePage 16, update CSX, RDX, DC/X, SDI, SDOPage 18, update DSWAPPage 19, correct typo for IM[3: 0]in MDDI+SCL(falling edge)Page 38&44, update typo for data format in table0.05Page 53, update read data 8-8-8-bit only in SPIKevinDenn2010/10/18Page 183, 184, update note for min porch of RGB interfacePage 232, update MTP sequence and MTP PWR voltagePage 235, 236, remove PWM ENH OE bit(keep x2Page 312, 314, update typo for BCTRL and BLPage 371, 372: update figuresPage 373: update figure, add RGB+l2CPage 374: update figures, IM settingPage 375: update figures, IM settingPage 15, update DVDD typicage 129, update typo in figure of AwERPage 194, update typo for Hsync218 add condition of irregulaoffPage 219, 255, update command name typo of 05h commandPage 228-231, update typo in figuresPage 234, update typo for ALS in figure 5. 22.10.1Page 235, update CLED VOL bit in figure 5. 22.2KevinDennis2010/12/24Page 312, 314, update typo for BCTRL bl bitsPage 316, update typo in flow chartPage 346, update description of parameterPage 355, update maximum rating for VGH, GlxPage 358, 359, update 2 lane description in conditionPage 362, update pin name typo in figure-Page 376, update typo for CRGB condition10/28/201110Version o 8With respect to the information represented in this document, Novatek makes no warranty, expressed or implied, including the warranties of merchantabilityfitness for a particular purpose, non-infringement, or assumes any legal liability or responsibility for the accuracy, completeness, or usefulness of any suchinformation
- 2020-12-05下载
- 积分:1
实验室安排管理系统
数据库,软件工程的实验室安排管理系统,很好的文档和代码。第一章引言1.1项目背景随着信息技术的普及,对计算机应用的普及,高等学校的计算机实验室在逐年上升,面对众多的计算机实验课,如何有效安排实验室,成为实验室管理人员的重要工作之一。为了提高实验室安排管理效率,方便教师对实验室的使用情况及时查询和申请实验室,需要设计一个能提供教师实时了解当前实验室教师申请情况,并可以对闲置实验室的申请,最后通过实验室管理员对教师所做的实验申请进行安排管理。本系统基于B/S结构,主要山前台教师对实验室申请和后台基本资料的维护及实验室的安排,主要包括以下功能:登录、申请实验、基本资料维护、实验室安排管理、用户管理,个人设置等。1.2实验室安排管理系统概述实验室安排管理系统是一门新兴的集管珪科学、信息科学、系统科学级计算机科学为一体的综合性学科,研究的是大学校园的实验室安排管理的全过程,以便有效的安排管理实验室信息,提高校园的实验室使用率,提供各类管理决策信息辅助实验室管理部门进行现代化管理。实验室安排管理系统是大学校园的实验空信息管理系统,它具备数据增加、修改、删除和査询功能,具体如下(1)对用户信息增加、修改、删除管理;(2)对实验室信息增加、修改、删除管理com3)对日期和课程信息增加、修改、删除管理(4)实验室安排管理1.3系统开发的意义为了有效的安排管理实验室信息,提高校园的实验室使用率,提供各类管理决策信息辅助实验室管理部门进行现代化管理需要设计一个能提供教师实时了解当前实验室教师申请情况,并可以对闲置实验室的申请,最后通过实验室管理员对教师所做的实验申请进行安排管理。本系统基于B/S结构,主要由前台教师对实验室申请和后台基本资料的维护及实验室的安排,主要包括以下功能:登录、申请实验、申请实习、基本资料维护、用户管理,个人设置、实验室安排管理等第二章系统分析2.1系统功能分析通过讨论分析,要求系统需要有以下功能:(1)要有良好的人机界面功能。(2)支持多用户操作,要求有较好的权限分配功能。(3)支持实验申请和实习申请多行录入功能。(4)为了方便用户能快速正确地申请到实验室,提供实验室申请浏览。(5)每个用户,课程,实验,实习,实验室都有惟一的编号即ID,编号需要是整型标识,能自动生成有序ID。(6)支持用户,课程,班级,实验室的修改,增加,删除功能。(7)支持实验室的安排浏览。2.2用户管理流程丁公共用户登录修改密退出→码图2-1用户管理流程com2.3实验管理流程用户登录系统—>申请实验—>修改申请—>查询申请结果申请实公共用户登录验,修改退出图2-2实验管理流程2.4实习管理流程用户登录系统—>申请实习—一>修改申请——一>查询申请结果申请实习,修改公共用户登录实习4退出图2-3实习管理流程2.5实验室安排系统管理流程管理员登录—>査询实验、实习申请—>安排实验室—>审核——>安排登录4添加、修改管理员册除用户退出管理实验室艹图2-4实验室安排系统管理流程docn豆丁www.docin.com第三章系统设计3.1项目规划本系统分为如下的几大模块:主界面登录模块实验室安排浏览模块用户控制面版实验宝查询用广管理实验审管理|报表图3-1系统模块图1、主界面模块该模块提供管理系统的主界面,是主系统的唯一入口和出口,该界面提供用户选择并调用各子模块2、登录根据用户管理分配不同的角色权限,核对用户,进入系统进行相应的操作。子模块:(1)用户控訇面版(公共用户)该模块提供用户的基本信息的界面,用户可在此修改密码、基本资料;察看本人申请实验室的情况。(2)实验室查询(老师)该模块提供査询符合某一条件的实验室安排情况的界面。(3)用户管理(管理员)该模块提供对用户信息进行更改、删除和新增和手动安排实验室的界面(4)实验室管理(管理员)该模块提供对实验室信息进行更改、删除和新增和手动安排实验室的界面。3、实验室安排浏览该模块提供全部实验室安排情況的界面。3.2功能框图用户查询更新查询更新查查更查查更更洵询更新结果询询新新条结条结条条结件|果果|件自果浏览申请表实验室安排表系统安排管理员审核图3-2主数据流程图3.3数据库设计创建数据库是设计系统的第·步,其关键问题在于确定所需的表结构并为之建立索引。为∫使系统设计精练实用,体现关系型数据库的特点,本系统还为各相关表建立关系。数据项设计通过需求分析,可确定系统的数据项和数据结构如下:实验申请表: shiyang(实验申请ID,周次,星期,节次,实验名称,实验班级,实验人数,任课教师,实验教师,申请时间实习申请I,周次,实习内容,实习课程名称,实习班级,实习人数,任课教师,申请时间)实习申请表 shixing(实习申请ID,周次,实习内容,实习课程名称,实习班级,实习人数,任课教师,申请时间)用户表:user(用户ID,用户名,用户类型)。班级表: classdb(班级ID,班级名称,班级入学时间)课程表:Kedb(课程ID,课程名称)实验室表: Ssdb(实验室ID,实验室名称,实验室座位)为了方便安排,本系统还设定了几个用于安排的临时表学年表: Xuelian(学年ID,学年名称)。学期表: xueqI(节次ID,节次名称)。周次表: Weekdb(周次ID,周次名称)。节次:jeci(节次I,节次名称)。实验表: shiyan(实验ID,实验名称)实习表: shixi(实习ID,实习名称)2、概念结构设计本系统在需求分析的基础上设计出能够满足用户需求的各种实体。根据上面的分析所得的实体有:实验室安排实体、用户实体。3、逻辑结构设计数据项描述{数据项名,数据类型,长度,数据项含义说明,可否为空}(1)用户表: Userdb用户表用来保存用信息,用户表结构如表3-1所示表3-1用户表数据项名数据类型(长度)数据项含义说明「可否为空user 1dint(4)用户ID否User-name char(20)用广名否User perchar(20)用户类型否(2)班级表: classdb班级表用来保存班级信息,班级表结构表3-2所示表3-2班级表数据项名数据类型(长度)数据项含义说明可否为空Class idInt(4)班级ID否Class nameChar(50)班级名称Class inyearChar(20)班级入学时间否3)实习申请表: shixia实习申请表用来保存实验申请信息,实习申请表结构表3-3所示表3-3实习申请表数据项名数据类型(长度)‖数据项含义说明「可否为空Shixing idInt(4)实习申请ID否Shixing week Char(20)周次否Shixing nameChar(100)实习内容否Shixing keChar(100)实习课程名称否Shixisg class Char(100)实习班级否Shixisq menInt(4)实习人数否Shixisq manChar(20)「任课教师否Shixing timeChar(20)申请时间可4)实验申请表: shiyang实验申请表用来保存实验申请信息,实验申请表结构如表3-4所示表34实验申请表数据项名数据类型(长|数据项含义说明「可否为空度)Shiyang idInt(4)实验申请ID否Shiyang weekChar(20周次Shiyang xqChar(20)星期Shiyang jcChar(20)节次否否否Shiyang nameCar(100实验名称Shiyang classChar(100)实验班级Shiyang menInt(4实验人数口Shiyang manar(2任课教师Shiyansq syteacher Char(20)实验教师Shiyang timeChar(20)申请时间(5)实验教师表: teacher实验教师表用来保存实验教师信息,实验教师表结构如表3-5所示表3-5实验教师表数据项名数据类型(长度)数据项含义说明「可否为空Teacher idInt(4)教师ID否Teacher nameChar(20)教师名称否(6)课程表:Kedb课程表用来保存课程信息,课程表结构如表3-6所示表3-6课程表数据项名数据类型(长度)数据项含义说明「可否为空Ke idInt(4)课程ID否Ke namelChar(100课程名称否(7)实验室表: Ssdb实验室表用来保存实验室信息,实验室表结构如表3-7所示表3-7实验室表数据项名数据类型(长度)数据项含义说明可否为空Sys idint(4)实验室ID否sys namechar(100)实验室名称否Sys menInt(4)实验室座位否(8)学年表: Xuelian学年表用来保存用信息,学年表结构如表3-8所示表3-8学年表数据项名数据类型(长度)数据项含义说明可否为空Xuenian idchar(20)学年ID否Xuwenlan nameint(20)学年名称否(9)周次表: Weekdb周次表用来保存周次信息,周次表结构如表39所示表3-9周次表数据项名数据类型(长度)「数据项含义说明「可否为空Week idchar (20)周次IDWeek nameint(20)周次名称否否(10)星期表: XIng星期表用来保存星期信息,星期表结构如表3-10所示表3-10星期表数据项名数据类型(长度)「数据项含义说明可否为空xing idchar(20)学年IDXIngl nameint(20)学年ID否否(11)节次表: J1eC1节次表用来保存节次信息,节次表结构如表3-11所示表3-11节次表数据项名数据类型(长度)数据项含义说明「可否为空c ldchar(20)班级名称合Jc nameint(20)编级人数4www.docin.com
- 2020-11-30下载
- 积分:1