Total Board(bankbook, notice etc.)
Tables (16)
ACCOUNT (통장개설정보)
- ACCOUNTNUM (계좌번호) — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
- BOOKNUMBER (일련번호) — NUMBER — Foreign key → BANKBOOK.BOOKNUMBER — NOT NULL
- ACCOUNTDATE (통장개설일) — DATE
- ACCOUNTBALANCE (전체잔액) — NUMBER
ADDRESS (주소정보)
- ADDRESSNUM (주소번호) — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
- ADDRESS (주소) — VARCHAR2(200)
- ADDRESSPHONE (주소전화번호) — VARCHAR2(200)
- ADDRESSNAME (주소명) — VARCHAR2(200)
BANKBOOK (통장)
- BOOKNUMBER (일련번호) — NUMBER — Primary key — NOT NULL
- BOOKNAME (통장이름) — VARCHAR2(200)
- BOOKRATE (이자율) — NUMBER(3,1)
- BOOKSALE (판매여부) — NUMBER
- BOOKDETAIL (상세정보) — VARCHAR2(200)
BANKBOOKCOMMENT (댓글)
- NUM (댓글번호) — NUMBER — Primary key — NOT NULL
- BOOKNUMBER (일련번호) — NUMBER — Foreign key → BANKBOOK.BOOKNUMBER — NOT NULL
- CONTENTS (댓글내용) — VARCHAR2(4000)
- REGDATE (작성일) — DATE
- WRITER (작성자) — VARCHAR2(200)
BANKBOOKIMG (상품이미지)
- FILENUM (파일번호) — NUMBER — Primary key — NOT NULL
- BOOKNUMBER (일련번호) — NUMBER — Foreign key → BANKBOOK.BOOKNUMBER — NOT NULL
- FILENAME (저장된파일명) — VARCHAR2(400)
- ORINAME (업로드시파일명) — VARCHAR2(400)
COMMENTARY (댓글1)
- COMMENTNUM (댓글번호) — NUMBER — Primary key — NOT NULL
- PRODUCTNUM (상품번호) — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
- ID — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
- COMMENTSCORE (평점) — NUMBER(2,1)
- COMMENTDATE (작성날짜) — DATE
- COMMENTARY (내용) — VARCHAR2(500)
MEMBER (은행회원정보)
- ID — VARCHAR2(200) — Primary key — NOT NULL
- PW — VARCHAR2(200)
- MEMBERNAME (이름) — VARCHAR2(200)
- MEMBERPHONE (전화번호) — VARCHAR2(200)
- EMAIL (이메일) — VARCHAR2(200)
MEMBER_ROLE (멤버-권한)
- ID — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
- ROLENUM (권한번호) — NUMBER — Foreign key → ROLE.ROLENUM — NOT NULL
NOTICE (공지사항)
- NUM (글번호) — NUMBER — Primary key — NOT NULL
- TITLE (글제목) — VARCHAR2(200)
- CONTENTS (글내용) — CLOB
- WRITER (작성자) — VARCHAR2(200)
- REGDATE (작성일) — DATE
- HIT (조회수) — NUMBER
NOTICEFILES (공지사항파일)
- FILENUM (파일번호) — NUMBER — Primary key — NOT NULL
- NUM (글번호) — NUMBER — Foreign key → NOTICE.NUM — NOT NULL
- FILENAME (파일명) — VARCHAR2(200)
- ORINAME (업로드명) — VARCHAR2(200)
PRODUCT (상품)
- PRODUCTNUM (상품번호) — NUMBER — Primary key — NOT NULL
- PRODUCTNAME (상품이름) — VARCHAR2(200)
- PRODUCTDETAIL (상품상세내용) — CLOB
- PRODUCTSCORE (평점) — NUMBER(2,1)
PRODUCTOPTION (상품옵션)
- OPTIONNUM (옵션번호) — NUMBER — Primary key — NOT NULL
- PRODUCTNUM (상품번호) — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
- OPTIONNAME (옵션명) — VARCHAR2(200)
- OPTIONPRICE (옵션가격) — NUMBER
- OPTIONSTOCK (옵션재고) — NUMBER
QNA (질문답변)
- NUM (글번호) — NUMBER — Primary key — NOT NULL
- TITLE (글제목) — VARCHAR2(200)
- CONTENTS (글내용) — CLOB
- WRITER (작성자) — VARCHAR2(200)
- REGDATE (작성일) — DATE
- HIT (조회수) — NUMBER
- REF (Field) — NUMBER
- STEP (Field2) — NUMBER
- DEPTH (Field3) — NUMBER
QNAFILES (질문답변파일)
- FILENUM (파일번호) — NUMBER — Primary key — NOT NULL
- NUM (글번호) — NUMBER — Foreign key → QNA.NUM — NOT NULL
- FILENAME (파일명) — VARCHAR2(200)
- ORINAME (업로드명) — VARCHAR2(200)
ROLE (권한)
- ROLENUM (권한번호) — NUMBER — Primary key — NOT NULL
- ROLENAME (권한이름) — VARCHAR2(200)
TRADE (거래내역)
- TRADENUM (일련번호) — NUMBER — Primary key — NOT NULL
- ACCOUNTNUM (계좌번호) — NUMBER — Foreign key → ACCOUNT.ACCOUNTNUM — NOT NULL
- TRADEBALANCE (거래후잔액) — NUMBER
- TRADETABLE (거래일) — DATE
- TRADEIO (입출금구분) — NUMBER
- TRADEAMOUNT (거래전잔액) — VARCHAR2(200)