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 (댓글내용) — varchar(40000)
- RegDate (댓글작성날짜) — Date
MemberFile (회원사진정보)
- FILENUM (파일번호) — Number — Primary key — NOT NULL
- USERNAME (회원ID) — Varchar2(200) — Foreign key → BankMembers.USERNAME — NOT NULL
- FILENAME (파일이름) — Varchar2(200)
- ORINAME (업로드명) — Varchar2(200)
MemberRole (등급)
- 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)