ㅁㅁㅁ
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