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