library
Tables (7)
ACCOUNT
- ACCNUM — NUMBER(20) — Primary key — NOT NULL
- ID — VARCHAR2(50) — NOT NULL
- PD_NAME — VARCHAR2(50) — NOT NULL
- AC_NAME — VARCHAR2(50)
- BALANCE — NUMBER(20)
- AC_OP_DATE — DATE
- AC_PASS — NUMBER(20)
- BANK_CODE — NUMBER(20)
BOARD
- POST_NUM — NUMBER(20) — Primary key — NOT NULL
- ID — VARCHAR2(50) — NOT NULL
- TITLE — VARCHAR2(50)
- CONTENT — VARCHAR2(10000)
- POST_DATE — DATE
- POST_TYPE — VARCHAR2(20)
COMMENT
- COMMENT_NUM — NUMBER(20) — Primary key — NOT NULL
- ID — VARCHAR2(50) — NOT NULL
- POST_NUM — NUMBER(20) — NOT NULL
- COM_DATE — DATE
- CONTENT — VARCHAR2(1000)
MONEY_HISTORY
- ACCNUM — NUMBER(20) — NOT NULL
- NAME — VARCHAR2(50)
- TARGET_NAME — VARCHAR2(50)
- MONEY — NUMBER(20)
- TRANSFER_DATE — DATE
- BANK_CODE — NUMBER(20)
PRODUCT
- PD_NAME — VARCHAR2(50) — Primary key — NOT NULL
- PD_DATE — DATE
- ID — VARCHAR2(50) — Foreign key → USER.ID — NOT NULL
REPLY
- REPLY_NUM — NUMBER(20) — Primary key — NOT NULL
- ID — VARCHAR2(50) — NOT NULL
- COMMENT_NUM — NUMBER(20) — NOT NULL
- REPLY_DATE — DATE
- REPLY_CONTENT — VARCHAR2(1000)
USER
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PASS — VARCHAR2(50)
- NAME — VARCHAR2(50)
- USERCODE — NUMBER(20)
- EMAIL — VARCHAR2(50)
- PHONE — NUMBER(20)
- POSTCODE — NUMBER(20)
- ADRESS — VARCHAR2(50)
- USERDATE — DATE
- ADMIN — VARCHAR2(50)