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)