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