Bank
Tables (6)
BANKBOOK (통장)
- BOOKNUM (일련번호) — Number — Primary key — NOT NULL
- BOOKNAME (통장이름) — Varchar2(200)
- BOOKRATE (이자율) — Number(4,2)
- BOOKSALE (판매여부) — Number(1)
BankMembers (회원)
- USERNAME (ID) — Varchar2(200) — Primary key — NOT NULL
- PASSWORD (비번) — Varchar2(200)
- NAME (이름) — Varchar2(200)
- Email (이메일) — Varchar2(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
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
MemberFile (회원사진)
- FILENUM (파일번호) — Number — Primary key — NOT NULL
- USERNAME (ID) — Varchar2(200) — Foreign key → BankMembers.USERNAME — NOT NULL
- FILENAME (저장된파일명) — Varchar2(400)
- ORINAME (업로드파일명) — Varchar2(200)
Role (회원등급)
- RoleNum (일련번호) — Number — Primary key — NOT NULL
- RoleName (등급이름) — Varchar2(200)