BOOK_ADMIN
Tables (13)
BOARD
- BOARD_NO — NUMBER — Primary key — NOT NULL
- BOARD_TITLE — VARCHAR(300)
- BOARD_CONTENT — VARCHAR(3000)
- BOARD_WRITE_TIME — DATE
- BOARD_COUNT — NUMBER
- MEMBER_ID — varchar2(20)
BOARD_COMMENT
- BOARD_COMMENT_NO — NUMBER — Primary key — NOT NULL
- BOARD_COMMENT_CONTENT — VARCHAR(1000)
- BOARD_COMMENT_TIME — DATE
- BOARD_COMMENT_NAME — VARCHAR2(30)
- BOARD_NO — NUMBER — NOT NULL
BOARD_COMMENT_LIKE
- MAMBER_IDV — VARCHAR2(30) — Primary key — NOT NULL
- BOARD_COMMENT_NO — NUMBER — NOT NULL
BOARD_COMMNET_HATE
- MAMBER_IDV — VARCHAR2(30) — Primary key — NOT NULL
- BOARD_COMMENT_NO — NUMBER — NOT NULL
BOARD_FILE
- BOARD_FOLE_NO — CHAR(10) — Primary key — NOT NULL
- FILE_URL — VARCHAR2(500)
- BOARD_NO — NUMBER — NOT NULL
BOARD_HATE
- MAMBER_IDV — VARCHAR2(30) — Primary key — NOT NULL
- BOARD_NO — NUMBER — NOT NULL
BOARD_LIKE
- MAMBER_IDV — VARCHAR2(30) — Primary key — NOT NULL
- BOARD_NO — NUMBER — NOT NULL
BOARD_MEMBER
- MEMBER_ID — varchar2(20)
- MEMBER_PW — CHAR(128)
- MEMBER_NAME — varchar2(30)
- Nickname — varchar2(30)
- GRADE_NO — NUMBER — NOT NULL
BOARD_MEMBER_GRADE
- GRADE_NO — NUMBER — Primary key — NOT NULL
- GRADE_NAME — VARCHAR2(30)
Untitled (BOOK)
- Key (BOOK_NO) — VARCHAR2(30) — Primary key — NOT NULL
- Field (BOOK_NAME) — VARCHAR2(30)
- Field (BOOK_WRITER) — VARCHAR2(30)
- Field (BOOK_PUBLISHER) — VARCHAR2(30)
Untitled (MEMBER)
- Key (MEMBER_ID) — VARCHAR2(30) — Primary key — NOT NULL
- Field (MEMBER_PASSWD) — VARCHAR2(30)
- Field (MEMBER_NAME) — VARCHAR2(30)
- Field (MEMBER_PHONE) — CHAR(11) — NOT NULL
- Field (MEMBER_BIRTH) — DATE — NOT NULL
Untitled (BOROOW)
- Field (BOROOW_DAY) — DATE
- Field (EXPECT_RETURN_DATE) — DATE
- Field (RETURN_DATE) — DATE
- Key (BOOK_NO) — VARCHAR2(30) — Foreign key → Untitled.Key — NOT NULL
- Key (MEMBER_ID) — VARCHAR2(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (BOROOW_STATE)
- Key (INSTANCE_BOOK_NO) — VATCHAR2(30) — Primary key
- Key (BOOK_NO) — VARCHAR2(30) — Foreign key → Untitled.Key
- Field (BOOK_STATE) — VARCHAR2(30)