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 (bank댓글)
- Key (댓글번호) — NUMBER — Primary key — NOT NULL
- BOOKNUM (통장일련번호) — NUMBER — Foreign key → BankBook.BOOKNUM — NOT NULL
- WRITER (댓글작성자) — VARCHAR2(200)
- CONTENTS (댓글내용) — VARCHAR2(40000)
- REGDATE (댓글작성일) — DATE
MemberFile (회원의 사진정보)
- FILENUM (파일번호) — NUMBER — Primary key — NOT NULL
- USERNAME (회원의 ID) — VARCHAR2(200) — Foreign key → BankMembers.USERNAME — NOT NULL
- FILENAME (파일명) — VARCHAR2(400)
- ORINAME (업로드시 파일명)
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 (등급이름)