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)