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