fastlms

Tables (4)

BANNER (배너)

  • ID — BIGINT — Primary key — NOT NULL
  • Field (이미지정보) — VARCHAR(255)
  • Field (제목) — VARCHAR(255)
  • Field (내용) — VARCHAR(255)
  • Field2 (클릭했을 때 이동하는 경로) — VARCHAR(255)
  • Field3 (경로 타입) — VARCHAR(255) — new브라우저/기존브라우저
  • Field4 (게시시간_시작일) — DATETIME
  • Field5 (게시시간_종료일) — DATETIME
  • Field6 (게시여부) — BOOL
  • Field (등록자) — VARCHAR(50)
  • Field2 (등록일자) — DATETIME
  • Field3 (수정자) — VARCHAR(50)
  • Field4 (수정일자) — DATETIME

COUESE (강좌 정보)

  • ID — BIGINT — Primary key — NOT NULL
  • Image_Path (이미지) — VARCHAR(255)
  • Keyword (키워드) — VARCHAR(255)
  • Subject (제목) — VARCHAR(255)
  • Summary (요약문구) — VARCHAR(1000)
  • Contents (상세내용) — TEXT
  • Price (정가) — INT
  • Sale_Price (현재_판매가) — INT
  • Sale_End_Dt (할인_종료일) — DATETIME

MEMBER (회원)

  • email (이메일) — VARCHAR(255) — Primary key — NOT NULL
  • name (이름) — VARCHAR(20)
  • phone_number (휴대폰번호) — VARCHAR(12)
  • password (비밀번호) — VARCHAR(250)

TAKE_COURSE (수강정보)

  • ID — BIGINT — Primary key — NOT NULL
  • Course_ID (강좌_ID) — BIGINT — Foreign key → COUESE.ID — NOT NULL
  • email (회원_이메일) — VARCHAR( 255) — Foreign key → MEMBER.email — NOT NULL
  • Pay_Price (결제금액) — INT
  • Status (수강정보_상태) — VARCHAR(20) — 수강신청/수강취소/결제완료