ㅁㅁㅁ

Tables (19)

BOOK_REVIEWS

  • BRS_NUM — NUMBER — Primary key — NOT NULL
  • Book_Num — NUMBER — Foreign key → Book.Book_Num — NOT NULL
  • Mem_Num — NUMBER — Foreign key → MEMBER.Mem_Num — NOT NULL
  • BRS_CONTENT — VARCHAR2(3000) — NOT NULL
  • BRS_RATING — NUMBER — NOT NULL
  • BRS_LIKE — NUMBER
  • BRS_HATE — NUMBER
  • BRS_CDATE — DATE
  • BRS_UPDATE — DATE

BOOK_REVIEWS_LOG

  • BRL_Num — NUMBER — Primary key — NOT NULL
  • BRS_NUM — NUMBER — Foreign key → BOOK_REVIEWS.BRS_NUM — NOT NULL
  • Mem_Num — NUMBER — Foreign key → MEMBER.Mem_Num — NOT NULL
  • BRL_LIKECHECK — NUMBER — NOT NULL
  • BRL_HATECHECK — NUMBER — NOT NULL
  • BRL_CDATE — DATE
  • BRL_UDATE — DATE

Board

  • B_Num — NUMBER — Primary key — NOT NULL
  • Mem_Num — NUMBER — Foreign key → MEMBER.Mem_Num — NOT NULL
  • B_Title — VARCHAR2(100) — NOT NULL
  • B_Content — VARCHAR2(3000) — NOT NULL
  • B_Rdate — Date — NOT NULL
  • B_View — NUMBER
  • B_Top — VARCHAR(255)

Book

  • Book_Num — NUMBER — Primary key — NOT NULL
  • Book_Code — NUMBER — Foreign key → CLASSIFICATION.Book_Code — NOT NULL
  • F_Num — NUMBER — Foreign key → Facility.F_Num — NOT NULL
  • Book_Title — VARCHAR2(200) — NOT NULL
  • Book_Writer — VARCHAR2(50)
  • Book_Publisher — VARCHAR2(50)
  • Book_ISBN — VARCHAR2(17) — NOT NULL
  • Book_Recomend — BOOLEAN — NOT NULL
  • Book_Count — NUMBER — NOT NULL
  • Book_Img — VARCHAR2(3000)

Book_Favorite

  • BF_Num — NUMBER — Primary key — NOT NULL
  • Mem_Num — VARCHAR2(50) — Foreign key → MEMBER.Mem_Num — NOT NULL
  • Book_Num — NUMBER — Foreign key → Book.Book_Num — NOT NULL

Book_Request

  • BR_Num — NUMBER — Primary key — NOT NULL
  • Mem_Num — NUMBER — Foreign key → MEMBER.Mem_Num — NOT NULL
  • BR_Title — VARCHAR2(50) — NOT NULL
  • BR_Writer — VARCHAR2(30) — NOT NULL
  • BR_ISBN — VARCHAR2(17) — NOT NULL

CLASSIFICATION

  • Book_Code — NUMBER — Primary key — NOT NULL
  • Code_Name — VARCHAR2(50) — NOT NULL

CLUB_APPLICATION

  • CA_NUM — NUMBER — Primary key — NOT NULL
  • CC_Num — NUMBER — Foreign key → Club_Calendar.CC_Num — NOT NULL
  • Mem_Num — NUMBER — Foreign key → Club_Calendar.Mem_Num — NOT NULL
  • CA_DATE — DATE

Club_Calendar

  • CC_Num — NUMBER — Primary key — NOT NULL
  • Mem_Num — NUMBER — Foreign key → MEMBER.Mem_Num — NOT NULL
  • CC_Subject — VARCHAR(200) — NOT NULL
  • cc_leader — VARCHAR2(500) — NOT NULL
  • CC_Date — Date — NOT NULL
  • CC_Catgo — VARCHAR2(50) — NOT NULL
  • CC_Content — VARCHAR2(500) — NOT NULL
  • CC_Times — NUMBER — NOT NULL
  • CC_HeadCount — NUMBER — NOT NULL
  • CC_RoundTopic — VARCHAR2(2000) — NOT NULL
  • CC_Detail — VARCHAR2(2000) — NOT NULL
  • CC_Img — VARCHAR2(500) — NOT NULL
  • CC_Like — NUMBER — NOT NULL
  • CC_OnOff — VARCHAR2(30) — NOT NULL

Club_Notice

  • CN_Num — NUMBER — Primary key — NOT NULL
  • Mem_Num — NUMBER — Foreign key → MEMBER.Mem_Num — NOT NULL
  • CN_Subject — VARCHAR2(500) — NOT NULL
  • CN_Img — VARCHAR2(300) — NOT NULL

Club_Review

  • CR_Num — NUMBER — Primary key — NOT NULL
  • CC_Num — NUMBER — Foreign key → Club_Calendar.CC_Num — NOT NULL
  • Mem_Num — NUMBER — Foreign key → MEMBER.Mem_Num — NOT NULL
  • CR_Detail — VARCHAR2(2000) — NOT NULL
  • CR_Rating — NUMBER — NOT NULL
  • CR_CDate — Date — NOT NULL

DVD

  • DVD_NUM — NUMBER — Primary key — NOT NULL
  • F_Num — NUMBER — Foreign key → Facility.F_Num — NOT NULL
  • DVD_TITLE — VARHCAR2(100) — NOT NULL
  • DVD_Content — VARCHAR2(3000)
  • DVD_Director — VARCHAR2(50) — NOT NULL
  • DVD_Rdate — DATE — NOT NULL
  • DVD_IMG — VARCHAR2(3000)

Facility

  • F_Num — NUMBER — Primary key — NOT NULL
  • F_Name — VARCHAR2(50) — NOT NULL
  • F_Floor — NUMBER — NOT NULL

MEMBER

  • Mem_Num — NUMBER — Primary key — NOT NULL
  • Mem_Email — VARCHAR2(50) — NOT NULL
  • Mem_Pass — VARCHAR2(50) — NOT NULL
  • Mem_Phone — VARCHAR2(20)
  • Mem_Id — VARCHAR2(50) — NOT NULL
  • Mem_Name — VARCHAR2(50) — NOT NULL
  • Mem_Grade — NUMBER — NOT NULL
  • MEM_SNS — VARCHAR2(20) — NOT NULL
  • Mem_Rdate — DATE
  • Mem_Udate — DATE

Rental

  • Ren_Num — NUMBER — Primary key — NOT NULL
  • Mem_Num — NUMBER — Foreign key → MEMBER.Mem_Num — NOT NULL
  • Book_Num — NUMBER — Foreign key → Book.Book_Num — NOT NULL
  • Ren_Borrow — DATE
  • Ren_Return — DATE
  • Ren_Stat — NUMBER

Reservation

  • Res_Num — NUMBER — Primary key — NOT NULL
  • Mem_Num — NUMBER — Foreign key → MEMBER.Mem_Num — NOT NULL
  • Seat_Seq — NUMBER — Foreign key → Seat.Seat_Seq — NOT NULL
  • Room_Start — DATE — NOT NULL
  • Room_End — DATE — NOT NULL

Seat

  • Seat_Seq — NUMBER — Primary key — NOT NULL
  • F_Num — NUMBER — Foreign key → Facility.F_Num — NOT NULL
  • Seat_Use — VARCHAR2(50) — NOT NULL
  • Seat_Num — VARCHAR2(50) — NOT NULL

SeatTime

  • Time_Seq — NUMBER — Primary key — NOT NULL
  • Seat_Seq — NUMBER — Foreign key → Seat.Seat_Seq — NOT NULL
  • F_Num — NUMBER — Foreign key → Seat.F_Num — NOT NULL
  • Seat_Time — NUMBER — NOT NULL
  • Seat_Time_Use — VARCHAR2(50) — NOT NULL

Untitled2

  • SEQ — NUMBER — Foreign key → Board.B_Num — NOT NULL
  • Mem_Num — NUMBER — Foreign key → MEMBER.Mem_Num — NOT NULL
  • content — VARCHAR2(500) — NOT NULL
  • RDATE — DATE — NOT NULL
  • UPDATE — DATE