OMSTORE
Tables (9)
Anncmnt (공지사항)
- AnncmntNo (공지사항번호) — Number — Primary key — NOT NULL
- UserID (아이디) — varchar2(50) — Foreign key → User.UserID — NOT NULL
- title (제목) — varchar2(200)
- registration (등록일) — date
- correction (수정일) — date
- views (조회수) — number
- content (내용) — clob
Comment (댓글)
- CommentID (댓글번호) — Number — Primary key — NOT NULL
- UserID (아이디) — varchar2(50) — Foreign key → User.UserID — NOT NULL
- FreeBoardNo (자유게시판번호) — Number — Foreign key → Free_Board.FreeBoardNo — NOT NULL
- AnncmntNo (공지사항번호) — Number — Foreign key → Anncmnt.AnncmntNo — NOT NULL
- EventNo (이벤트글번호) — Number — Foreign key → Event.EventNo — NOT NULL
- Content (내용) — clob
- registration (등록일) — date
- correction (수정일) — date
Event (이벤트게시판)
- EventNo (이벤트글번호) — Number — Primary key — NOT NULL
- UserID (아이디) — varchar2(50) — Foreign key → User.UserID — NOT NULL
- title (제목) — varchar2(200)
- registration (등록일) — date
- correction (수정일) — date
- views (조회수) — number
- content (내용) — clob
Free_Board (자유게시판)
- FreeBoardNo (게시글번호) — Number — Primary key — NOT NULL
- UserID (아이디) — varchar2(50) — Foreign key → User.UserID — NOT NULL
- title (제목) — varchar2(200)
- registration (등록일) — date
- correction (수정일) — date
- views (조회수) — number
- content (내용) — clob
Order (주문정보)
- OrderNo (주문번호) — Number — Primary key — NOT NULL
- UserID (아이디) — varchar2(50) — Foreign key → User.UserID — NOT NULL
- delivery (배송상태) — varchar2(50)
- contact (연락처) — number
- address (배송지) — clob
- memo (메모) — clob
- cnt (갯수) — number
- price (총가격) — number
QnA (고객문의)
- QnANo (QnA번호) — number — Primary key — NOT NULL
- UserID (유저 아이디) — varchar2(50) — Foreign key → User.UserID — NOT NULL
- Content (내용) — clob
Review (리뷰)
- No (리뷰번호) — number — Primary key — NOT NULL
- UserID (아이디) — varchar2(50) — Foreign key → User.UserID — NOT NULL
- ProductsID (상품번호) — number — Foreign key → products.ProductsID — NOT NULL
- content (상품후기) — clob
- score (상품점수) — varchar2(50)
User (회원정보)
- UserID (아이디) — varchar2(50) — Primary key — NOT NULL
- name (이름) — varchar2(50)
- pwd (비밀번호) — vachar2(50)
- email (이메일) — varchar2(50)
- birthdate (생년월일) — date
- address (주소) — varchar2(50)
- phone (연락처) — number
- Rating (등급) — varchar2(50)
- Point (마일리지) — number
products (상품)
- ProductsID (상품번호) — number — Primary key — NOT NULL
- name (상품명) — varchar2(100)
- price (가격) — number
- category (카테고리) — varchar2(100)
- status (상품상태) — varchar2(50)
- inventory (재고) — number
- registration (등록일) — date
- correction (수정일) — date
- image (상품이미지) — clob