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)