MAV

Tables (10)

AdminImages

  • clublistImage — text
  • classlistImage — text
  • mainslideImage1 — text
  • mainslideImage2 — text
  • mainslideImage3 — text

Classes

  • classNum — int
  • classId — varchar(15) — NOT NULL
  • className — varchar(15) — NOT NULL
  • classLectureDate — date — NOT NULL
  • classLectureTime — time — NOT NULL
  • classNumberOfStudents — int — NOT NULL
  • classCourseContents — text
  • classGrade — varchar(20) — NOT NULL
  • classIntroduction — text
  • classImagesFileName1 — text
  • classImagesFileName2 — text
  • classImagesFileName3 — text
  • classImagesFileName4 — text
  • classImagesFileName5 — text
  • classLocale — varchar(100) — NOT NULL
  • classApprove — boolean
  • teacherId — varchar(15)

Club

  • clubNum — int
  • clubName — varchar(30) — NOT NULL
  • clubMaster — varchar(15) — NOT NULL
  • clubCategory — varchar(5) — NOT NULL
  • clubLocale — varchar(5) — NOT NULL
  • clubPoint — int
  • imageFileName1 — text
  • imageFileName2 — text
  • imageFileName3 — text
  • imageFileName4 — text
  • imageFileName5 — text
  • clubInfo — text

ClubMember

  • clubName — varchar(20)
  • c_memberId — varchar(15)
  • clubGrade — varchar(5)
  • clubApprove — boolean

Matching

  • matchNum — INT
  • matchTitle — varchar(30) — NOT NULL
  • roomNum — int
  • creatorId — varchar(15)
  • applicantId — varchar(15)
  • matchStatus — VARCHAR(255)
  • matchResult — VARCHAR(255)

Member

  • memberName — varchar(10) — NOT NULL
  • memberPassword — varchar(20) — NOT NULL
  • memberBirth — date — NOT NULL
  • memberAddr — varchar(100) — NOT NULL
  • memberPhone01 — varchar(3) — NOT NULL
  • memberPhone02 — varchar(4) — NOT NULL
  • memberPhone03 — varchar(4) — NOT NULL
  • memberGender — varchar(2) — NOT NULL
  • memberEmail — varchar(30) — NOT NULL
  • adminApprove — boolean

Notice

  • noticeNum — int
  • noticeWriter — varchar(15) — NOT NULL
  • noticeTitle — varchar(50) — NOT NULL
  • noticeContents — text
  • noticeHits — int
  • noticeDate — Date

Room

  • roomNum — INT
  • storeId — varchar(15) — NOT NULL
  • roomName — varchar(20) — NOT NULL
  • roomCapacity — int — NOT NULL
  • roomCount — int — NOT NULL
  • roomCategory — varchar(10) — NOT NULL
  • roomDetail — text
  • roomDate — date — NOT NULL
  • roomTime — time — NOT NULL
  • Matched — int

Store

  • storeId — varchar(15)
  • storeName — varchar(50) — NOT NULL
  • storeAddr — varchar(100) — NOT NULL
  • storeCategory — varchar(50) — NOT NULL
  • storePhone01 — varchar(3) — NOT NULL
  • storePhone02 — varchar(4) — NOT NULL
  • storePhone03 — varchar(4) — NOT NULL
  • storeImageName1 — text
  • storeImageName2 — text
  • storeImageName3 — text
  • storeImageName4 — text
  • storeImageName5 — text
  • storeInfomation — text
  • storeNotice — text
  • storeCode — varchar(15) — NOT NULL
  • storeApprove — boolean
  • latitude — DECIMAL(10, 8)
  • longitude — DECIMAL(11, 8)

Teacher

  • teacherId — varchar(15)
  • teacherimageFileName — text
  • teacherCategory — varchar(10)
  • teacherRecode — varchar(10)
  • LicenseimageFileName1 — text
  • LicenseimageFileName2 — text
  • LicenseimageFileName3 — text
  • LicenseimageFileName4 — text
  • LicenseimageFileName5 — text
  • teacherInfomation — text
  • teacherApprove — boolean