Team6

Tables (12)

Author

  • Author_id — int(10) — Primary key — NOT NULL
  • Author_name — varhcar(50) — NOT NULL
  • Affiliation (Affilliation) — varchar(50)
  • Carrer — varhcar(5000)

Book

  • Book_id — int(12) — Primary key — NOT NULL
  • Publisher_id (Publishcer_id) — int(10) — Foreign key → Publisher.Publisher_id — NOT NULL
  • Author_id — int(10) — Foreign key → Author.Author_id — NOT NULL
  • Title — varchar(50)
  • Edition — int(3)
  • CategoryName — varchar(50) — Trigger 넣기
  • ISBN — int(13)
  • NumerOfPages (NumberOfPages) — int(5)
  • PublicationYear — datetime

Branch (Tree_edit)

  • Branch_id (Edit_id) — int(12) — Primary key — NOT NULL
  • TM_id (Book_tree_id) — int(10) — Foreign key → Tree_making.TM_id — NOT NULL
  • User_id — int(10) — Foreign key → User.User_ID — NOT NULL
  • Action — int(1) — NOT NULL — Create,Delete
  • Private — boolean — NOT NULL — 공개여부

Buy_certification

  • Buy_id — int(10) — Primary key — NOT NULL
  • User_id — int(10) — Foreign key → User.User_ID — NOT NULL
  • Store_id — int(10) — Foreign key → Store.Store_id — NOT NULL
  • Book_id — int(12) — Foreign key → Book.Book_id — NOT NULL
  • Recipt — varchar(100) — NOT NULL — 이미지링크

Ordering (Untitled)

  • ordering_id (Key) — int(12) — Primary key — NOT NULL
  • Branch_id (Edit_id) — int(12) — Foreign key → Branch.Branch_id — NOT NULL
  • Book_id — int(12) — Foreign key → Book.Book_id — NOT NULL
  • bookorder (Field) — boolean — NOT NULL — True=start, False=End

Publisher

  • Publisher_id (Publishcer_id) — int(10) — Primary key — NOT NULL
  • Publisher_name — varchar(50) — NOT NULL

Review

  • Review_id — int(10) — Primary key
  • User_id — int(10) — Foreign key → User.User_ID — NOT NULL
  • TM_id (Key) — int(10) — Foreign key → Tree_making.TM_id — NOT NULL
  • Review (Review_content) — varchar(500) — 후기
  • Star_review — float(2) — NOT NULL — 별점
  • Like — int(6)

Stock

  • Book_id — int(12) — Foreign key → Book.Book_id — NOT NULL
  • Store_id — int(10) — Foreign key → Store.Store_id — NOT NULL
  • Stock — int(5)

Store

  • Store_id — int(10) — Primary key — NOT NULL
  • Store_name — varchar(50) — NOT NULL
  • Location — varchar(100)

Tag

  • Tag_id — int(10) — Primary key — NOT NULL
  • Branch_id (Edit_id) — int(12) — Foreign key → Branch.Branch_id — NOT NULL
  • Tag_name (Event_name) — varchar(20) — NOT NULL
  • Registration_date (Field) — datetime — NOT NULL

Tree_making (Book_tree)

  • TM_id (Book_tree_id) — int(10) — Primary key — NOT NULL
  • inquery_date (Field) — datetime — NOT NULL
  • img_link (Field2) — varchar(500)

User

  • User_ID (User_id) — int(10) — Primary key — NOT NULL
  • Job — varchar(50)
  • Belong — varchar(50)
  • Detailed_belong (Field) — varchar(50)
  • Interest — varchar(50)