Bank

Tables (7)

ACCOUNT (Untitled)

    BANKBOOK (통장)

    • BOOKNUM (통장일렬번호) — NUMBER — Primary key — NOT NULL
    • BOOKNAME (통장이름) — VARCHAR2(200)
    • BOOKRATE (이자율) — NUMBER(4,1)
    • BOOKSALE (판매여부) — NUMBER(1)

    BB_Comment (뱅크북 댓글)

    • NUM (댓글번호) — NUMBER — Primary key — NOT NULL
    • BOOKNUM (통장일렬번호) — NUMBER — Foreign key → BANKBOOK.BOOKNUM — NOT NULL
    • WRITER (작성자) — VARCHAR2(200)
    • CONTENTS (댓글내용) — VARCHAR2(4000)
    • REGDATE (댓글작성날짜) — DATE

    BankMembers (회원)

    • ID (회원의 아이디) — Varchar2(200) — Primary key — NOT NULL
    • PASSWORD (비번) — Varchar2(200)
    • NAME (이름) — Varchar2(200)
    • Email (이메일) — Varchar2(200)
    • Phone (전화번호) — Varchar2(200)

    MemberFile (회원의 photo정보)

    • FILENUM (파일번호) — Number — Primary key — NOT NULL
    • ID (회원의 아이디) — Varchar2(200) — Foreign key → BankMembers.ID — NOT NULL
    • FILENAME (저장된 파일명) — varchar2(400)
    • oriName (upload시 파일명) — varchar2(200)

    Member_Role (등급)

    • NUM (식별) — Number — Primary key — NOT NULL
    • ID (회원의 아이디) — Varchar2(200) — Foreign key → BankMembers.ID — NOT NULL
    • RoleNum (일련번호) — Number — Foreign key → Role.RoleNum — NOT NULL

    Role (회원등급)

    • RoleNum (일련번호) — Number — Primary key — NOT NULL
    • RoleName (등급이름) — Varchar2(200)