인프런 서비스
테이블 (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)