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