umc실습
테이블 (9)
Member (Untitled)
- id (PK) — bigint — 기본 키 — NOT NULL
- token (Field5)
- name (Field) — varchar(10)
- nickname (Field2) — varchar(10)
- phone_num (Field3) — varchar(15)
- gender (Field4) — tinyint(1)
- created_at (Field6) — datetime(6)
- updated_at (Field7) — datetime(6)
- status (Field8) — varchar(15)
- inactive_date (Field9) — datetime
alarm (Untitled3)
- id (PK) — bigint — 기본 키 — NOT NULL
- content (Field)
- id (FK) — bigint — 외래 키 → alarm_type.id — NOT NULL
alarm_member (Untitled9)
- id (PK) — bigint — 외래 키 → Member.id — NOT NULL
- id (PK2) — bigint — 외래 키 → alarm.id — NOT NULL
alarm_type (Untitled8)
- id (PK) — bigint — 기본 키 — NOT NULL
- type_name (Field)
book (Untitled2)
- id (PK) — bigint — 기본 키 — NOT NULL
- title (Field) — varchar(40)
- description (Field2) — text
- member_id (FK) — 외래 키 → Member.id — NOT NULL
- category_id (FK2) — 외래 키 → category.id — NOT NULL
- created_at (Field3) — datetime(6)
- updated_at (Field4) — datetime(6)
book_hashtag (Untitled6)
- id (PK) — bigint — 외래 키 → book.id — NOT NULL
- Key — bigint — 외래 키 → hashtag.id — NOT NULL
category (Untitled4)
- id (PK) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(20)
- created_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
hashtag (Untitled5)
- id (PK) — bigint — 기본 키 — NOT NULL
- name (Field)
like (Untitled7)
- id (PK) — bigint — 외래 키 → Member.id — NOT NULL
- id (PK2) — 외래 키 → book.id — NOT NULL