enjoytrip
테이블 (8)
Untitled (article_image)
- Key (id) — bigint — 기본 키 — NOT NULL
- id (article_id) — bigint — 외래 키 → 게시글.id — NOT NULL
- Field (image_name) — varchar(50) — NOT NULL
- Field2 (image_uuid) — varchar(50) — NOT NULL
- Field3 (created_at) — datetime(6) — NOT NULL
- Field4 (created_by) — varchar(50) — NOT NULL
- Field5 (updated_at) — datetime(6) — NOT NULL
- Field (updated_by) — varchar(50) — NOT NULL
member
- 회원 id (id) — bigint — 기본 키 — NOT NULL
- asd (email) — varchar(50) — NOT NULL
- (password) — varchar(50) — NOT NULL
- name — varchar(50) — NOT NULL
- Field4 (age) — bigint — NOT NULL
- Field5 (gender) — varchar(50) — NOT NULL
- Field (phone_number) — varchar(50) — NOT NULL
- created_at — datetime(8) — NOT NULL
- created_by — varchar(50) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- Field (updated_by) — varchar(50) — NOT NULL
message
- Key (id) — bigint — 기본 키 — NOT NULL
- 회원 id (member_id) — bigint — 외래 키 → member.회원 id — NOT NULL
- Key (message_room_id) — bigint — 외래 키 → messageRoom.Key — NOT NULL
- Field (content) — text — NOT NULL
- Field2 (created_at) — datetime(6) — NOT NULL
- Field3 (created_by) — varchar(50) — NOT NULL
- Field4 (updated_at) — datetim(6) — NOT NULL
- Field5 (updated_by) — varchar(50) — NOT NULL
messageRoom (message_room)
- Key (id) — bigint — 기본 키 — NOT NULL
- id (article_id) — bigint — 외래 키 → 게시글.id — NOT NULL
- 회원 id (sender_id) — bigint — 외래 키 → member.회원 id — NOT NULL
- 회원 id (receiver_id) — bigint — 외래 키 → member.회원 id — NOT NULL
- Field (created_at) — datetime(6) — NOT NULL
- Field2 (created_by) — varchar(50) — NOT NULL
- Field3 (updated_at) — datetime(6) — NOT NULL
- Field4 (updated_by) — varchar(50) — NOT NULL
게시글 (article)
- id — bigint — 기본 키 — NOT NULL
- 회원 id (member_id) — bigint — 외래 키 → member.회원 id — NOT NULL
- (title) — varchar(50) — NOT NULL
- Field3 (content) — varchar(50) — NOT NULL
- Field6 (views) — bigint — NOT NULL
- Field7 (atype) — varchar(50) — NOT NULL
- created_at — datetime(6) — NOT NULL
- Field (created_by) — varchar(50) — NOT NULL
- Field2 (updated_at) — datetime(6) — NOT NULL
- updated_by — varchar(50) — NOT NULL
댓글 (comment)
- Key (id) — bigint — 기본 키 — NOT NULL
- 회원 id (member_id) — bigint — 외래 키 → member.회원 id — NOT NULL
- id (article_id) — bigint — 외래 키 → 게시글.id — NOT NULL
- Field3 (child_id) — bigint — NOT NULL
- content — text — NOT NULL
- created_at — datetime(6) — NOT NULL
- created_by — varchar(50) — NOT NULL
- Field7 (updated_at) — datetime(6) — NOT NULL
- Field8 (updated_by) — varchar(50) — NOT NULL
좋아요 (like)
- id — bigint — 기본 키 — NOT NULL
- 회원 id (member_id) — bigint — 외래 키 → member.회원 id — NOT NULL
- id (article_id) — bigint — 외래 키 → 게시글.id — NOT NULL
- created_at — datetime(6) — NOT NULL
- Field4 (created_by) — varchar(50) — NOT NULL
- Field5 (updated_at) — datetime(6) — NOT NULL
- Field6 (updated_by) — varchar(50) — NOT NULL
히스토리 (history)
- id — bigint — 기본 키 — NOT NULL
- table_name — varchar(50)
- Field2 (column_name) — varchar(50)
- Field3 (action) — varchar(50)
- (created_at) — datetime(6)
- Field5 (created_by) — varchar(50)
- Field (updated_at) — datetime(6)
- updated_by — varchar(50)