DB individual 3
Tables (16)
Author (Untitled2)
- AuthorID (Key) — int(10) — Primary key — NOT NULL
- Name (Field) — varchar(50)
- Affiliation (Field2) — varhcar(50)
- Carrer (Field3) — varchar(5000)
- AuthorDataRegistrationDate (Field4) — date
Book (Untitled)
- BookNumber (Key) — int(12) — Primary key — NOT NULL — unique
- LocationID (Key4) — int(3) — Foreign key → Location.LocationID — NOT NULL
- Title (Field7) — varchar(50)
- Edition (Field2) — int(3)
- CategoryName (Field) — varchar(50)
- ISBN (Field3) — int(13)
- NumberOfPages (Field6) — int(5)
- PublicationYear (Field4) — date
Book (CopyOfUntitled)
- Book_id (Key) — int(12) — Primary key — NOT NULL — unique
- AuthorID (Key2) — int(10) — Foreign key → Author.AuthorID — NOT NULL
- PublisherID (Key3) — int(10) — Foreign key → Publisher.PublisherID — NOT NULL
- Title (Field7) — varchar(50)
- Edition (Field2) — int(3)
- CategoryName (Field) — varchar(50)
- ISBN (Field3) — int(13)
- NumberOfPages (Field6) — int(5)
- PublicationYear (Field4) — date
- Field5
Book_tree (Untitled12)
- Tree_id (Key2) — Primary key — NOT NULL
- Edit_id (Key) — int(12) — Foreign key → Tree_edit.Edit_id — NOT NULL
- Book_id (Key3) — int(12) — Foreign key → Book.Book_id — NOT NULL — unique
- Event_id (Key4) — Foreign key → Event.Event_id — NOT NULL
Buy_certification (Untitled15)
- Buy_id (Key) — Primary key — NOT NULL
- User_id (Key3) — Foreign key → User(Student).User_id — NOT NULL
- Book_id (Key2) — int(12) — Foreign key → Book.Book_id — NOT NULL — unique
- Store_id (Key4) — Foreign key → Store.Store_id — NOT NULL
- Recipt (Field) — varchar(100)
Event (Untitled13)
- Event_id (Key) — Primary key — NOT NULL
- Event_name (Field) — 물리학 강의, 작가 연대순/수상작
- Date (Field2)
- Rank (Field3)
- Sponsor (Field4)
Location (Untitled7)
- LocationID (Key) — int(3) — Primary key — NOT NULL
- LocationName (Field) — varchar(50)
Order (Untitled5)
- OrderID (Key) — int(10) — Primary key — NOT NULL
- UniversityPersonID (Key2) — int(10) — Foreign key → UniversityPerson.UniversityPersonID — NOT NULL
- BookNumber (Key3) — int(12) — Foreign key → Book.BookNumber — NOT NULL — unique
- OrderDate (Field2) — date
- OrderStatus (Field) — int(3)
- Deliverydate (Field3) — date
Publisher (Untitled3)
- PublisherID (Key) — int(10) — Primary key — NOT NULL
- Name (Field) — varchar(50)
Rental (Untitled6)
- RentalID (Key) — int(13) — Primary key — NOT NULL
- UniversityPersonID (Key2) — int(10) — Foreign key → UniversityPerson.UniversityPersonID — NOT NULL
- BookNumber (Key3) — int(12) — Foreign key → Book.BookNumber — NOT NULL
- RentalDate (Field) — date
- ReturnDate (Field2) — date
- RetalStatus (Field3) — int(1)
Review (Untitled10)
- Review_id (Key) — Primary key — NOT NULL
- User_id (Key2) — Foreign key → User(Student).User_id — NOT NULL
- Tree_id (Key22) — Foreign key → Book_tree.Tree_id — NOT NULL — 트리에 관한 리뷰
- Book_id (Key3) — int(12) — Foreign key → Book.Book_id — NOT NULL — unique
- Review (Field) — varchar
- Star_reivew (Field2)
- Like (Field3)
Stock (Untitled9)
- Stock_id (Key) — Primary key — NOT NULL
- Book_id (Key2) — int(12) — Foreign key → Book.Book_id — NOT NULL — unique
- Store_id (Key3) — Foreign key → Store.Store_id — NOT NULL
- Stock (Field) — int(5)
Store (Untitled8)
- Store_id (Key) — Primary key — NOT NULL
- Store_name (Field)
- Location (Field2)
Tree_edit (Untitled14)
- Edit_id (Key) — int(12) — Primary key — NOT NULL
- User_id (Key2) — Foreign key → User(Student).User_id — NOT NULL
- Action (Field) — Create, Add, Delete
- Private (Field2) — boolean — 공개 여부
- Start_Book (Field3)
- End_Book (Field4)
UniversityPerson (Untitled4)
- UniversityPersonID (Key) — int(10) — Primary key — NOT NULL
- Name (Field) — varchar(50)
- Type (Field2) — int(3)
User(Student) (Untitled11)
- User_id (Key) — Primary key — NOT NULL
- Job (Field)
- Belong (Field2)
- Interest (Field3)