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)