인프런 서비스

테이블 (3)

Copy Of course (CopyOfcourse)

  • course_id (Key) — 기본 키 — NOT NULL
  • l_category (Field)
  • s_catetory (Field2)
  • title (Field3) — varchar(200)
  • content (Field4) — nvarchar(500)
  • price (Field5) — double
  • indomation (Field6) — nvarchar(1000)
  • level (Field7) — char(1)
  • user_id (Field8) — bigint
  • reg_dt (Field9) — datetime
  • chg_dt (Field10) — datetime

course

  • course_id (Key) — 기본 키 — NOT NULL
  • l_category (Field)
  • s_catetory (Field2)
  • title (Field3) — varchar(200)
  • content (Field4) — nvarchar(500)
  • price (Field5) — double
  • indomation (Field6) — nvarchar(1000)
  • level (Field7) — char(1)
  • user_id (Field8) — bigint
  • reg_dt (Field9) — datetime
  • chg_dt (Field10) — datetime

student (Student)

  • user_id (Key) — bigint — 기본 키 — NOT NULL
  • gender (Field) — char(1)
  • email (Field2) — varchar(20)
  • password (Field3) — varchar(100)
  • nickname (Field4) — varchar(20)
  • role (Field5) — char(1)
  • introducation (Field6) — nvarchar(200)
  • phone (Field7) — varchar(11)
  • profile_url (Field8)
  • profile_img (Field9)
  • reg_dt (Field10)
  • chg_dt (Field11)