Bank
Tables (6)
BankBook (통장)
- BookNum (일련번호) — Number — Primary key — NOT NULL
- BookName (통장 이름) — varchar2(200)
- BookRate (이자율) — Number(4, 2)
- BookSale (통장 판매 여부) — Number(1)
Comment (BankBook댓글)
- Num (댓글의 번호) — Number — Primary key — NOT NULL
- BookNum (일련번호) — Number — Foreign key → BankBook.BookNum — NOT NULL
- Writer (댓글의 작성자) — varchar2(200)
- Contents (댓글의 내용) — varchar2(4000)
- RegDate (댓글 작성 날짜) — Date
Role (회원등급)
- RoleNum (Key) — number — Primary key — NOT NULL
- Rolename (Field) — varchar2(200)
- Field2
memberFiles (회원의 이미지 정보)
- fileNum (Key) — number — Primary key — NOT NULL
- username (Key2) — Foreign key → memebers.username — NOT NULL
- filename (Field) — varchar2(400)
- oriname (Field2) — varchar2(200)
- Field3
member_role (등급)
- num (Key) — number — Primary key — NOT NULL
- username (Key2) — Foreign key → memebers.username — NOT NULL
- RoleNum (Key3) — number — Foreign key → Role.RoleNum — NOT NULL
memebers (Untitled)
- username (Key) — Primary key — NOT NULL
- password (Field)
- name (Field2)
- email (Field3)
- phone (Field4)
- Field5