Advertisement
badlogic

Migration table

Jul 16th, 2016
199
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.84 KB | None | 0 0
  1. TBL_CATEGORYGRADES
  2.   -CAT_GRADESID(primary key)
  3.   -SID(int)
  4.   -GID(int)
  5.   -CATGRADES_GRADE(var)
  6.  
  7. TBL_CLIENTINFO
  8. -CI_ID(primary key)
  9. -CO_COMPANYINFO(var)
  10.  
  11. TBL_FGRADES
  12. -FGRADE_ID(primary key)
  13. -SID(int)
  14. -STUDNO(var)
  15. -SYID(int)
  16. -LEVELID(int)
  17. -SECTIONID(int)
  18. -SUBJECTID(int)
  19. -FOURTGRADING(decimal)
  20. -FINALGRADE(decimal)
  21. -REMARKS(var)
  22. -RANK(int)
  23.  
  24. TBL_GRADES
  25. -GRADEID(primary key)
  26. -SID(int)
  27. -STUD_NO(var)
  28. -SUBID(int)
  29. -GID(int)
  30. -SCORE(int)
  31. -GRADE(decimal)
  32. CATGRADES_GRADE(decimal)
  33.  
  34. TBL_GRADINGCATEGORY
  35. -GID(primary key)
  36. -SUBJECTID(int)
  37. -LEVELID(int)
  38. -QID(int)
  39. -SECTIONID(int)
  40. -GRADECATEGORY(var)
  41. -PERCENTAGE(decimal)
  42. -NOITEMS(int)
  43.  
  44. TBL_LEVELGRADE
  45. -SYTRANID(primary key)
  46. -LEVELID(int)
  47. -SYID(int)
  48. -GRADELEVELID(int)
  49.  
  50. TBL_QUARTER
  51. -QID(primary)
  52. -QUARTER(var)
  53.  
  54. TBL_SCHOOLYEAR
  55. -SYID(primary)
  56. -SCHOOLYEAR(var)
  57. -ISACTIVE(bolean)
  58.  
  59. TBL_SECTIONTRAN
  60. -SECTIONID(primary)
  61. -SYTRANID(int)
  62. -SECTIONNAME(var)
  63. -ADVISEE(bolean)
  64. -BASE_GRADE(int)
  65.  
  66. TBL_STUDENTINFO
  67. -SID(int)
  68. -STUDNO(var)
  69. -LNAME(var)
  70. -FNAME(var)
  71. -MNAME(var)
  72. -GENDER(var)
  73. -ADDRESS(var)
  74. -GRADELEVEL(int)
  75. -SECTIONID(int)
  76. -SCHOOLYEARID(int)
  77.  
  78. TBL_SUBCATEGORY
  79. -SUBID(primary)
  80. -GID(int)
  81. GRADECATEGORYSUB(var)
  82. -NOITEMS(int)
  83.  
  84. TBL_SUBJECT
  85. -SUBJID(primary)
  86. -SUBJECTNAME(var)
  87.  
  88. TBL_SUBJECTTRAN
  89. -SUBJECTID(primary)
  90. -SYID(int)
  91. -LEVELID(int)
  92. -SECTIONID(int)
  93. -SUBJECTNAME(var)
  94. -SCHEDULE(var)
  95.  
  96. TBL_TEACHERINFO
  97. -TID(int)
  98. -LNAME(var)
  99. -FNAME(var)
  100. -MNAME(var)
  101. -LICENSENO(var)
  102. -EMPID(var)
  103. -USERNAME(var)
  104. -PASSWORDX(var)
  105. -GENDER(var)
  106. -DISTRICT(var)
  107. -CITY(var)
  108.  
  109. TBL_MONTH
  110. -MONTHID(primary)
  111. -MONTHNAME(var)
  112.  
  113. TEMPSUBJECT
  114. -SUBJID(primary)
  115. -SUBJECT_NAME(var)
  116. -WEIGHT(decimal)
  117.  
  118. SYNCTASK
  119. -SYNCID(primary)
  120. -SYNCSTMT(var)
  121.  
  122. LEARNINGAREA
  123. -LAID(primary)
  124. -LANAME(var)
  125.  
  126. TEMPCATEGORY
  127. -TGID(primary)
  128. -SUBJECTID(int)
  129. -GRADECATEGORY(var)
  130. -PERCENTAGE(dec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement