bank
Tables (6)
BANKMEMBERS (회원)
- USER_NAME (Key) — VARCHAR2(200) — Primary key — NOT NULL
- PASSWORD (Field) — VARCHAR2(200)
- NAME (Field2) — VARCHAR2(200)
- EMAIL (Field3) — VARCHAR2(200)
- PHONE (Field4) — VARCHAR2(200)
BankBook (뱅크북)
- BOOKNUM (뱅크북 번호) — NUMBER — Primary key — NOT NULL
- BOOKNAME (이름) — VARCHAR2(200)
- BOOKRATE (이자율) — NUMBER(4,1)
- BOOKSALE (판매여부) — NUMBER(1)
Comment (뱅크북 댓글)
- NUM (댓글의 번호) — NUMBER — Primary key — NOT NULL
- BOOKNUM (뱅크북 번호) — NUMBER — Foreign key → BankBook.BOOKNUM — NOT NULL
- WRITER (댓글의 작성자) — VARCHAR2(200)
- REGDATE (댓글의 작성날짜) — DATE
- CONTENTS (댓글내용) — VARCHAR2(4000)
MEMBERFILE (Untitled)
- FILENUM (Key) — NUMBER — Primary key — NOT NULL
- USER_NAME (Key2) — VARCHAR2(200) — Foreign key → BANKMEMBERS.USER_NAME — NOT NULL
- FILENAME (Field) — VARCHAR2(400)
- ORINAME (Field2) — VARCHAR2(400)
MEMBER_ROLE (등급)
- NUM (식별) — NUMBER — Primary key — NOT NULL
- USER_NAME (Key) — VARCHAR2(200) — Foreign key → BANKMEMBERS.USER_NAME — NOT NULL
- RoleNum (일련번호) — Number — Foreign key → ROLL.RoleNum — NOT NULL
ROLL (회원등급)
- RoleNum (일련번호) — Number — Primary key — NOT NULL
- RoleName (등급이름) — varchar2(200)