YMTProject

Tables (5)

Member (member)

  • ID — varchar2(30) — Primary key — NOT NULL
  • password — varchar2(30)
  • name — varchar2(20)
  • 권한여부 (right) — number(2) — 권한 default는 0으로 하고, 전환하기 누르면 1으로 값이 update(query) 되면서 글쓰기 hidden버튼 show되도록.
  • email — varchar2(50)
  • phone — number(13)

Posting (posting)

  • 게시물번호(수강) (bno) — number — Primary key — NOT NULL
  • ID — varchar2(30) — Foreign key → Member.ID — NOT NULL
  • title — varchar2(20) — NOT NULL
  • category — number(20) — NOT NULL
  • count — number(100) — NOT NULL
  • 게시물승인여부 (postright) — number(2) — NOT NULL
  • 강습이자 (date) — date — NOT NULL
  • 강습시간 (time) — date — NOT NULL
  • 가격 (price) — number — NOT NULL
  • con1 — varchar2(2000)
  • con2 — varchar2(2000)
  • con3 — varchar2(2000)
  • con4 — varchar2(2000)

Review (review)

  • ID — varchar2(30) — Foreign key → Member.ID — NOT NULL
  • 게시물번호(수강) (bno) — number — Foreign key → Posting.게시물번호(수강) — NOT NULL
  • content — varchar2(500)
  • 별점 (score) — number

cart

  • wish — number
  • buyer — number
  • seller — number
  • id — varchar2(30)

upload

  • uuid — varchar2(100)
  • uploadpath — varchar2(200)
  • filename — varchar2(100)
  • filetype — char(1)