pre.study.spring7
Tables (3)
Untitled (comments)
- Key (id) — bigserial — Primary key — NOT NULL
- Field (post_id) — bigint — NOT NULL — posts .id
- Field (user_id) — bigint
- Field (username)
- Field (content)
- Field (inserted_at)
- Field (updated_at)
- Field (is_deleted) — char(1)
- Field (deleted_at) — timestamp
posts
- id — bigserial — Primary key — NOT NULL
- title — varchar(100) — NOT NULL
- user_id — bigint — users.id
- author_name — varchar(20) — NOT NULL — user_id = 0 이면 해당 값도 익명
- content — text
- lock_yn — char(1) — NOT NULL
- post_pwd — varchar(16)
- inserted_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- Field (is_deleted) — char(1) — NOT NULL
- Field (deleted_at) — timestamp — 삭제처리되었을때 update
users
- id — bigserial — Primary key — NOT NULL
- user_id — varchar(16) — NOT NULL
- user_pwd — varchar(100) — NOT NULL
- user_name — varchar(100) — NOT NULL
- role — varchar(10) — NOT NULL
- inserted_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- last_login_at — timestamp — NOT NULL — 해당 컬럼 저장 여부 결정해야 함
- Field (is_deleted) — char(1) — NOT NULL
- Field (deleted_at) — timestamp — 삭제 처리 되었을 때 update