세미
테이블 (8)
BOARD (Untitled3)
- BO_NO (Key) — VARCHAR2(36CHAR) — 기본 키 — NOT NULL
- USER_ID (Field) — VARCHAR2(36CHAR)
- UPDATE_DATE (Field2) — DATE
- TITLE (Field3) — VARCHAR2(50CHAR)
- CONTENT (Field4) — VARCHAR2(2000CHAR)
- STATUS (Field5) — VARCHAR2(1BYTE)
- USER_ID (Key2) — VARCHAR2(40CHAR) — 외래 키 → REPLY.USER_ID — NOT NULL
BOOK (Untitled2)
- BOOK_NO (Key) — VARCHAR2(40CHAR) — 기본 키 — NOT NULL
- CATEGORY (Field) — VARCHAR2(40CHAR)
- TITLE (Field2) — VARCHAR2(100CHAR)
- AUTHOR (Field3) — VARCHAR2(50CHAR)
- INFO (Field4) — VARCHAR2(500CHAR)
- RENT_NO (Field5) — NUMBER(1000)
- RB_NO (Key2) — VARCHAR2(36CHAR) — 외래 키 → RETN_MEMBER.RB_NO — NOT NULL
- RB_NO (Key3) — VARCHAR2(36CHAR) — 외래 키 → RENT_BOOK.RB_NO — NOT NULL
MEMBER (Untitled)
- USER_ID (Key) — VARCHAR2(40CHAR) — 기본 키 — NOT NULL — 회원아이디
- USER_PWD (Field1) — VARCHAR2(40CHAR) — 회원비밀번호
- EMAIL (Field2) — VARCHAR2(40CHAR) — 회원명
- GRADE (Field3) — VARCHAR2(40CHAR) — 닉네임
- PHONE (Field4) — VARCHAR2(20CHAR) — 전화번호
- MODIFY_DATE (Field5) — VARCHAR2(20CHAR) — 이메일
- STATUS (Field6) — VARCHAR2(20CHAR)
- BO_NO (Key2) — VARCHAR2(36CHAR) — 외래 키 → BOARD.BO_NO — NOT NULL
- NOTICE_NO (Key3) — VARCHAR2(36CHAR) — 외래 키 → NOTICE.NOTICE_NO — NOT NULL
- RB_NO (Key4) — VARCHAR2(36CHAR) — 외래 키 → RETN_MEMBER.RB_NO — NOT NULL
NOTICE (Untitled4)
- NOTICE_NO (Key) — VARCHAR2(36CHAR) — 기본 키 — NOT NULL
- USER_ID (Field) — VARCHAR2(36CHAR)
- UPDATE_DATE (Field2) — DATE
- TITLE (Field3) — VARCHAR2(50CHAR)
- CONTENT (Field4) — VARCHAR2(2000CHAR)
- STATUS (Field5) — VARCHAR2(1BYTE)
- USER_ID (Key2) — VARCHAR2(40CHAR) — 외래 키 → REPLY.USER_ID — NOT NULL
RENT_BOOK (Untitled5)
- RB_NO (Key) — VARCHAR2(36CHAR) — 기본 키 — NOT NULL
- BOOK_NO (Field) — VARCHAR2(40CHAR)
- RENT_DATE (Field2) — DATE
- RETURN_DATE (Field3) — DATE
- EXTENSION_DATE (Field4) — NUMBER
- RENT_CNT (Field5) — NUMBER
- STATUS (Field6) — VARCHAR2(1BYTE)
REPLY (Untitled7)
- USER_ID (Key) — VARCHAR2(40CHAR) — 기본 키 — NOT NULL
- REPLY_NO (Field) — NUMBER
- REPLY_CONTENT (Field2) — VARCHAR2(400BYTE)
- REF_BNO (Field3) — NUMBER
- CREATE_DATE (Field4) — DATE
- STATUS (Field5) — VARCHAR2(1 BYTE)
RETN_MEMBER (Untitled6)
- RB_NO (Key) — VARCHAR2(36CHAR) — 기본 키 — NOT NULL
- USER_ID (Field) — VARCHAR2(40CHAR)
- RENT_DATE (Field2) — DATE
- TITLE (Field3) — VARCHAR2(50CHAR)
- RENT_BOOK_CNT (Field4) — NUMBER