acu
Tables (13)
Academy (Untitled8)
- academyId (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(100)
- address (Field2) — varchar(100)
- telNumber (Field3) — varchar(100)
- studentNumber (Field4) — int
- starScore (Field5) — double
- keyword (Field6) — varchar(100)
AcademyOwner (Untitled2)
- uid (Key2) — int — Foreign key → Member.uid — NOT NULL
- role (Field2) — Varchar(100)
- certificationStatus (Field) — boolean
AdultLearner (Untitled3)
- uid (Key) — int — Foreign key → Member.uid — NOT NULL
- isTestDone (Field) — boolean
Club (Untitled6)
- clubId (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(100)
- fixedNumber (Field2) — int
- currentNumber (Field3) — int
Comment (Untitled5)
- commentId (Key) — int — Primary key — NOT NULL
- postId (Key2) — int — Foreign key → Post.postId — NOT NULL
- comment (Field) — varchar(100)
- Field2
Course (Untitled9)
- courseId (Key) — int — Primary key — NOT NULL
- academyId (Key2) — int — Foreign key → Academy.academyId — NOT NULL
- name (Field) — varchar(100)
- instructor (Field2) — varchar(100)
- price (Field3) — int
- currentStudentNumber (Field4) — int
- maxStudentNumber (Field5) — int
- startDate (Field6) — datetime
- endDate (Field7) — datetime
- category (Field8) — varchar(100)
Inquiry (Untitled11)
- id (Key) — int — Primary key — NOT NULL
- title (Field) — varchar(100)
- content (Field2) — varchar(100)
- isAnswered (Field3) — boolean
- registerDate (Field4) — datetime
- answerDate (Field5) — datetime
- uid (Key2) — int — NOT NULL
Member (Untitled)
- uid (Key) — int — Primary key — NOT NULL
- email (Field) — Varchar(100)
- password (Field2) — Varchar(100)
- name (Field3) — Varchar(100)
- nickname (Field4) — Varchar(100)
- phoneNumber (Field5) — Varchar(100)
- profile (Field6) — Varchar(100)
- propensity (Field7) — Varchar(100)
Payment (Untitled10)
- paymentId (Key) — int — Primary key — NOT NULL
- uid (Field) — int
- courseId (Field2) — int
- paymentDate (Field3) — datetime
- price (Field4) — int
Post (Untitled4)
- postId (Key) — int — Primary key — NOT NULL
- uId (Field4) — int
- title (Field) — Varchar(100)
- content (Field2) — Varchar(100)
Propensity (Untitled7)
- pId (Key) — int — Primary key — NOT NULL
- question (Field) — varchar(100)
- keyword (Field2) — varchar(100)
Question (Untitled12)
- qid (Key) — int — Primary key — NOT NULL
- title (Field) — varchar(100)
- content (Field2) — varchar(100)
- isAnswered (Field3) — boolean
- registerDate (Field4) — datetime
- answerDate (Field5) — datetime
- userId (Field6) — int
- courseId (Field7) — int
Refund (CopyOfUntitled10)
- refundId (Key) — int — Primary key — NOT NULL
- uid (Field) — int
- courseId (Field2) — int
- refundDate (Field3) — datetime
- price (Field4) — int