Bank
Tables (6)
BANKBOOK (통장)
- BOOKNUM (통장일련번호) — NUMBER — Primary key — NOT NULL
- BOOKNAME (통장이름) — VARCHAR2(200)
- BOOKRATE (이자율) — NUMBER(4, 2)
- BOOKSALE (판매여부) — NUMBER(1)
- BOOKCONTENTS (통장소개) — CLOB
BANKMEMBERS (회원)
- USERNAME (회원ID) — VARCHAR2(200) — Primary key — NOT NULL
- PASSWORD (비번) — VARCAHR2(200)
- NAME (이름) — VARCHAR2(200)
- EMAIL (이메일) — VAHRCAHR2(200)
- PHONE (전화번호) — VARCHAR2(200)
Comment (뱅크북댓글)
- NUM (댓글번호) — NUMBER — Primary key — NOT NULL
- BOOKNUM (통장일련번호) — NUMBER — Foreign key → BANKBOOK.BOOKNUM — NOT NULL
- WRITER (댓글 작성자) — VARCHAR2(200)
- CONTENTS (댓글 내용) — VARCHAR2(4000)
- REGDATE (댓글작성날짜) — DATE
MEMBERFILE (회원의photo정보)
- FILENUM (파일번호) — NUMBER — Primary key — NOT NULL
- USERNAME (회원ID) — VARCHAR2(200) — Foreign key → BANKMEMBERS.USERNAME — NOT NULL
- FILENAME (저장된파일명) — VARCHAR2(400)
- ORINAME (upload시 파일명) — VARCHAR2(200)
MEMBER_ROLE (등급)
- NUM (식별) — NUMBER — Primary key — NOT NULL
- USERNAME (회원ID) — VARCHAR2(200) — Foreign key → BANKMEMBERS.USERNAME — NOT NULL
- RoleNum (일련번호) — NUMBER — Foreign key → ROLE.RoleNum — NOT NULL
ROLE (회원등급)
- RoleNum (일련번호) — NUMBER — Primary key — NOT NULL
- RoleName (등급이름) — VARCHAR2(200)