TinyHome
Tables (4)
board
- board_id — bigint — Primary key — NOT NULL
- category_id (category_id2) — bigint — Foreign key → category.category_id — NOT NULL
- mem_id (mem_id2) — bigint — Foreign key → member.mem_id — NOT NULL
- category_id_category_id — bigint
- mem_id_mem_id — bigint
- content — varchar(255)
- title — varchar(255)
category
- category_id — bigint — Primary key — NOT NULL
- category_name — varchar(255)
member
- mem_id — bigint — Primary key — NOT NULL
- member_age — int
- email — varchar(255)
- member_name — varchar(255)
- member_pw — varchar(255) — NOT NULL
refresh_token
- id — bigint — Primary key — NOT NULL
- mem_id (mem_id2) — bigint — Foreign key → member.mem_id — NOT NULL
- created_at — datetime(6)
- expiry_date — datetime(6) — NOT NULL
- mem_id — bigint — NOT NULL
- token — varchar(512) — NOT NULL