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