Cafe
Tables (5)
Copy Of Copy Of user4 (user_modify_log)
- id — int — Primary key — NOT NULL — Auto Increment
- id (user_id) — bigint — Foreign key → user.id — NOT NULL
- Field (user_name) — varchar(16) — NOT NULL
- Field (user_name_modify_time) — datetime
- Field (user_password_modify_time) — datetime
Copy Of user (article)
- id — bigint — Primary key — NOT NULL — Auto Increment
- Field2 (user_login_id) — varchar(10) — NOT NULL
- Field (title) — varchar(10) — NOT NULL
- Field5 (contents) — text(1000) — NOT NULL
- Field3 (is_deleted) — boolean — NOT NULL
- Field (has_reply) — boolean — NOT NULL
Copy Of user2 (reply)
- id — bigint — Primary key — NOT NULL — Auto Increment
- Field2 (article_id) — bigint — NOT NULL
- Field (user_login_id) — varchar(10) — NOT NULL
- Field5 (contents) — text(1000) — NOT NULL
- Field3 (create_time) — datetime — NOT NULL — DEFAULT CURRENT_TIMESTAMP
Copy Of user4 (account_type)
- id — int — Primary key — NOT NULL
- Field5 (name) — varchar(10) — NOT NULL
user
- id — bigint — Primary key — NOT NULL — Auto Increment
- Field3 (email) — varchar(320) — NOT NULL — 로그인 수단
- Field (password) — varchar(256) — NOT NULL — 수정 가능
- Field5 (name) — varchar(16) — NOT NULL
- id (account_type) — int — Foreign key → Copy Of user4.id — NOT NULL — 0: 네이버 로그인, 1: 카카오 로그인, 2: 구글 로그인
- Field (create_time) — datetime — NOT NULL
- Field4 (is_locked) — boolean — NOT NULL — DEFAULT FALSE