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)