aku
Tables (9)
Post (Untitled2)
- post_id — int — Primary key — NOT NULL — PK
- user_id — int — Foreign key → member.user_id — NOT NULL — FK
- title — str — NOT NULL
- content — str
- upload_date (udate) — datetime — NOT NULL
- views — int — NOT NULL
- likes — int
book (Untitled5)
- book_id — int — Primary key — NOT NULL — PK
- title — str — NOT NULL
- author — varchar(255) — NOT NULL
- publisher — varchar(255) — NOT NULL
- published_date (pdate) — date — NOT NULL
- sold_count (scount) — int — NOT NULL
- is_best_seller (is_best) — boolean — NOT NULL
- price — int — NOT NULL
- new_book_id (Key) — int — Foreign key → new_book.new_book_id — NOT NULL — PK
category (Untitled6)
- category_id (c_id) — int — Primary key — NOT NULL — PK
- book_id (Key2) — int — Foreign key — NOT NULL — FK
- content — str — NOT NULL
comment (Untitled3)
- com_id — int — Primary key — NOT NULL — PK
- user_id — int — Primary key — NOT NULL — FK
- post_id — int — Foreign key → Post.post_id — NOT NULL — FK
- content — str — NOT NULL
- upload_date (udate) — datetime — NOT NULL
- likes — int
member (Untitled)
- user_id — int — Primary key — NOT NULL — PK
- email — varchar(40)
- password (pw) — varchar(40)
- nickname (nick) — varchar(15)
- phone_num (Field) — str
- name — varchar(15)
- birthday (bday) — date
new_book (Untitled8)
- new_book_id (Key) — int — Primary key — NOT NULL — PK
- new_book_date (n_book_date) — date — NOT NULL
- new_book_order (n_book_order) — int
- is_displayed — boolean — NOT NULL
- is_sold_out (is_sold) — boolean — NOT NULL
preferred_genres
- genre_id — int — Primary key — PK
- user_id — int — Foreign key → member.user_id — NOT NULL — PK
store (Untitled7)
- store_id — int — Primary key — NOT NULL — PK
- book_id — int — Foreign key → book.book_id — NOT NULL — FK
- store_name (s_name) — varchar(255) — NOT NULL
- store_url (s_url) — varchar(255) — NOT NULL
wishlist (Untitled4)
- wishlist_id (wish_id) — int — Primary key — NOT NULL — PK
- user_id — int — Foreign key → member.user_id — NOT NULL — FK
- book_id — int — Foreign key → book.book_id — NOT NULL — FK