Local_Lib_ERD

Tables (4)

BOOK (도서테이블)

  • PK (BOOK_ID) — NUMBER — Primary key — NOT NULL
  • Field (BOOK_NAME) — VARCHAR2(500)
  • Field2 (AUTHOR) — VARCHAR2(100)
  • Field3 (PUBLISHER) — VARCAHAR2(50)
  • Field4 (ISBN) — VARCHAR2(13)
  • Field5 (KDC) — NUMBER(3)
  • Field6 (INDATE) — DATE DEFAULT SYSDATE NOT NULL
  • FK (OWNER_ID) — VARCHAR2(20) — NOT NULL
  • Field8 (STATE_GB) — NUMBER(1)

MESSAGE (안내메세지 및 채팅메시지)

  • PK (MESSAGE_ID) — NUMBER — Primary key — NOT NULL
  • Field (ROOM) — NUMBER
  • Field2 (SENDER_ID) — VARCHAR(2)
  • Field3 (RECEIVER_ID) — VARCHAR2(20)
  • Field4 (CONTEXT) — VARCHAR2(4000)
  • Field5 (TYPE) — NUMBER(1)
  • Field6 (ISBN) — NUMBER(13)
  • Field7 (SEND_DATE) — DATE
  • Field8 (RECEIVE_DATE) — DATE
  • Field9 (BOOK_ID) — NUMBER
  • Field10 (RENT_ID) — NUMBER

RENT_RECORD (대여 이력테이블)

  • PK (RENT_ID) — NUMBER — Primary key — NOT NULL
  • Field (USER_ID) — VARCHAR(20)
  • Field2 (BOOK_ID) — NUMBER
  • Field3 (RENT_DATE) — DATE
  • Field4 (RETURN_DATE) — DATE
  • Field5 (EXTEND_GB) — NUMBER(1)
  • Field6 (EXTEND_DATE) — DATE
  • Field7 (OWNER_RENT_CK) — NUMBER(1)
  • Field8 (OWNER_RENT_CK_DATE) — NUMBER(1)
  • Field9 (RENT_CK) — NUMBER(1)
  • Field10 (RENT_CK_DATE) — DATE
  • Field11 (OWNER_RETURN_CK) — NUMBER(1)
  • Field12 (OWNER_RETURN_CK_DATE) — DATE
  • Field13 (RETURN_CK) — NUMBER(1)
  • Field14 (RETURN_CK_DATE) — DATE

USER_INFO (계정)

  • PK (USER_ID) — VARCHAR(20) PRIMARY KEY — Primary key — NOT NULL
  • Field (PW) — VARCHAR2(200) NOT NULL
  • Field2 (NAME) — VARCHAR2(20) NOT NULL
  • Field3 (NICKNAME) — VARCHAR2(20)
  • Field4 (PHONE) — VARCHAR2(13) UNIQUE NOT NULL
  • Field5 (PHONE_AUTH) — NUMBER(1) DEFAULT 0
  • Field6 (POSTCODE) — VARCHAR2(6)
  • Field7 (ADDR1) — VARCHAR2(100)
  • Field8 (ADDR2) — VARCHAR2(100)
  • Field9 (EMAIL) — VARCHAR2(50) NOT NULL
  • Field10 (BIRTHDAY) — DATE
  • Field11 (GENDER) — NUMBER(1)
  • Field12 (USER_GB) — NUMBER(1) DEFAULT 2 NOT NULL
  • Field13 (JOIN_DATE) — DATE DEFAULT SYSDATE NOT NULL
  • Field14 (STATE_GB) — NUMBER(1)