세미

테이블 (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

Untitled8

  • Field
  • Field2
  • Field3