6th
Tables (7)
book (Untitled2)
- id (아이디) — Primary key — NOT NULL
- name (제목)
- discription (설명)
- created_at (생성일)
- update_at (Field)
- category_id (카테고리 아이디) — Foreign key → category.id — NOT NULL
book_hash_tag (Untitled7)
- id (아이디) — Primary key — NOT NULL
- book_id (책 아이디) — Foreign key → book.id — NOT NULL
- hash_tag_id (해시태그아이디) — Foreign key → hash_tag.id — NOT NULL
- created_at (Field)
- updated_at (Field2)
category (Untitled4)
- id (아이디) — Primary key — NOT NULL
- name (이름)
- created_at (생성일)
- updated_at (수정일)
hash_tag (Untitled5)
- id (아이디) — Primary key — NOT NULL
- name (이름)
- created_at (Field)
- updated_at (Field2)
like (Untitled6)
- id (아이디) — Primary key — NOT NULL
- member_id (Key) — Foreign key → member.id — NOT NULL
- book_id (아이디2) — Foreign key → book.id — NOT NULL
- created_at (Field)
- updated_at (Field2)
member (Untitled)
- id (Key) — Primary key — NOT NULL
- name (이름)
- nickname (닉네임)
- phone_num (전화번호)
- gender (성별)
- created_at (Field)
- updated_at (Field2)
- status (Field3)
- inactive_date (Field4)
rent (Untitled3)
- id (아이디) — Primary key — NOT NULL
- member_id (Key) — Foreign key → member.id — NOT NULL
- book_id (아이디2) — Foreign key → book.id — NOT NULL
- created_at (Field)
- updated_at (Field2)