DB설계
테이블 (12)
Board (list)
- Bno (bno) — NUMBER(4) — 기본 키 — NOT NULL
- Title (title) — VARCHAR2(50)
- Writer (writer) — VARCHAR2(50)
- Content (content) — VARCHAR2(2000)
- RegDate (regdate) — DATE
- Cnt (cnt) — NUMBER(4)
- SearchCondition (searchCondition) — VARCHAR2(50)
- SearchKeyword (searchKeyword) — VARCHAR2(100)
- BFile (bfile) — VARCHAR2(1000)
- ID (id) — NUMBER(5) — 외래 키 → Users.ID — NOT NULL
Board (reply)
- Rno (rno) — NUMBER(4) — 기본 키 — NOT NULL
- Bno (bno) — NUMBER(4) — 외래 키 → Board.Bno — NOT NULL
- Replyer (replyer) — VARCHAR2(50)
- Reply (reply) — VARCHAR2(200)
- ReplyDate (replyDate) — DATE
- UpdateDate (updateDate) — DATE
Main (title)
- Title No (titleNo) — NUMBER(7) — 기본 키 — NOT NULL
- Title (title) — VARCHAR2(100)
- Synopsis (synopsis) — VARCHAR2(500)
- Actor (actor) — VARCHAR2(100)
- Director (director) — VARCHAR2(20)
- Release Date (releaseDate) — DATE
- Age (age) — NUMBER(3)
- Series (series) — char(1)
- Poster (poster) — VARCHAR2(200)
- Back Img (backImg) — VARCHAR(200)
- ID (id) — NUMBER(5) — 외래 키 → Users.ID — NOT NULL
Main (video)
- Video No (videoNo) — NUMBER(7) — 기본 키 — NOT NULL
- Title No (titleNo) — NUMBER(7)
- Video Title (videoTitle) — VARCHAR2(100)
- Video Episode No (videoEpisodeNo) — NUMBER(7)
- Video Thumbnail (videoThumbnail) — VARCHAR2(200)
- Video Watch Time (videoWatchTime) — NUMBER(10)
- Video Url (videoUrl) — VARCHAR2(200)
- Title No (title_no2) — NUMBER(7) — 외래 키 → Main.Title No — NOT NULL
Main (grade)
- Grade No (gradeNo) — NUMBER(7) — 기본 키 — NOT NULL
- User No (userNo) — NUMBER(7)
- Title No (titleNo) — NUMBER(7)
- Grade (grade) — NUMBER(5, 2)
- Title No (titleNo2) — NUMBER(7) — 외래 키 → Main.Title No — NOT NULL
Main (viewList)
- View No (viewNo) — NUMBER(7) — 기본 키 — NOT NULL
- User No (userNo) — NUMBER(7)
- Title No (titleNo) — NUMBER(7) — 외래 키 → Main.Title No — NOT NULL
- View Date (viewDate) — Date
- Last View Date (lastViewDate) — DATE
Main (titleItem)
- Title Item No (titleItemNo) — NUMBER(7) — 기본 키 — NOT NULL
- Item No (itemNo) — NUMBER(5) — 외래 키 → Main.Item No — NOT NULL
- Title No (titleNo) — NUMBER(7) — 외래 키 → Main.Title No — NOT NULL
Main (item)
- Item No (itemNo) — NUMBER(5) — 기본 키 — NOT NULL
- Item Option (itemOption) — char(1)
- Item Name (itemName) — VARCHAR(20)
Notice (List)
- Seq (seq) — NUMBER(4) — 기본 키 — NOT NULL
- Title (title) — VARCHAR2(50)
- Content (content) — VARCHAR2(2000)
- RegDate (regDate) — DATE
- Cnt (cnt) — NUMBER(4)
- SearchCondition (searchCondition) — VARCHAR2(50)
- SearchKeyword (searchKeyword) — VARCHAR2(100)
- NFile (nfile) — VARCHAR2(1000)
- ID (id) — NUMBER(5) — 외래 키 → Users.ID — NOT NULL
Reason (Untitled2)
- no — number(2) — 기본 키 — NOT NULL
- Reason (reason) — varchar2(400)
Users (Untitled)
- ID (id) — NUMBER(5) — 기본 키 — NOT NULL
- User Id (user_id) — VARCHAR2(50)
- Nickname (nickname) — VARCHAR2(50)
- Password (password) — VARCHAR2(50)
- Email (email) — VARCHAR2(50)
- Birthday (birthday) — DATE
- Gender (gender) — CHAR(1)
- Favorite Genre1 (favorite_genre1) — VARCHAR2(100)
- Favorite Genre2 (favorite_genre2) — VARCHAR2(100)
- Favorite Genre3 (favorite_genre3) — VARCHAR2(100)
- Rank (rank) — NUMBER(1)
- Manager (manager) — NUMBER(2)
Users (locker)
- User id (userId) — number(2) — 기본 키 — NOT NULL
- value — number(2)
- ID (id) — NUMBER(5) — 외래 키 → Users.ID — NOT NULL