4thStudy
Tables (10)
career
- id — INTEGER — Primary key — NOT NULL
- UserId — INTEGER — Foreign key → user.id — NOT NULL
- title — VARCHAR(200)
- createdAt — DATETIME
- updatedAt — DATETIME
checkBook
- id — INTEGER — Primary key — NOT NULL
- StudentId — INTEGER — Foreign key → user.id — NOT NULL
- LectureSchId — INTEGER — Foreign key → lectureSch.id — NOT NULL
- checktime — DATETIME
- createdAt — DATETIME
- updatedAt — DATETIME
lecture
- id — INTEGER — Primary key — NOT NULL
- LectureTypeId — INTEGER — Foreign key → lecture Type.id — NOT NULL
- TeacherId (TeacterId) — INTEGER — Foreign key → user.id — NOT NULL
- title — VARCHAR(200)
- subject — VARCHAR(100)
- description — VARCAHR(2000)
- thumbnail — VARCHAR(3000)
- Istop — TINYINT
- priceOfMonth — INTEGER
- discount — INTEGER
- location — VARCHAR(300)
- createdAt — DATETIME
- updatedAt (updateAt) — DATETIME
- isDelete — TINYINT
- deletedAt — DATETIME
- startDate (startdate) — DATE
- endDate — DATE
- isMon — TINYINT
- isTue — TINYINT
- isWed — TINYINT
- isFri — TINYINT
- isSat — TINYINT
- isSun — TINYINT
- time — DATE
lecture Type
- id — INTEGER — Primary key — NOT NULL
- value — VARCHAR(100)
- isDelete — TINYINT
- deletedAt — DATETIME
lectureContent
- id — INTEGER — Primary key — NOT NULL
- LectureId — INTEGER — Foreign key → lecture.id — NOT NULL
- LectureTypeId — INTEGER — Foreign key → lecture.LectureTypeId — NOT NULL
- TeacherId — INTEGER — Foreign key → lecture.TeacherId — NOT NULL
- value — VARCHAR(100)
- createdAt — DATETIME
- updatedAt — DATETIME
lectureSch
- id — INTEGER — Primary key — NOT NULL
- LectureId — INTEGER — Foreign key → lectureContent.LectureId — NOT NULL
- targetDate — DATE
- isRest — TINYINT
- isCompleted — TINYINT
- completedAt — DATETIME
- memo — VARCHAR(2000)
- createdAt — DATETIME
- updatedAt — DATETIME
major
- id — INTEGER — Primary key — NOT NULL
- userId — INTEGER — Foreign key → user.id — NOT NULL
- UserId — INTEGER
- title — VARCHAR(200)
- createdAt — DATETIME
- updatedAt — DATETIME
notice
- id — INTEGER — Primary key — NOT NULL
- title — VARCHAR(300)
- desripthion (discription) — TEXT
- hit — INTEGER
- Field
participants
- id — INTEGER — Primary key — NOT NULL
- StudentId — INTEGER — Foreign key → user.id — NOT NULL
- LectureId — INTEGER — Foreign key → lecture.id — NOT NULL
- createdAt — DATETIME
- updatedAt — DATETIME
user
- id — INTEGER — Primary key — NOT NULL
- userId — VARCHAR(100)
- userPassword — VARCHAR(100)
- useType — INTEGER
- username — VARCHAR(50)
- email — VARCHAR(100)
- moblie (mobile) — VARCHAR(20)
- birth — DATE
- gender — TINYIN
- loc — VARCHAR(100)
- belongs — VARCHAR(100)
- createdAt — DATETIME
- updatedAt — DATETIME
- isExited — TINYINT
- extiedAt — DATETIME