ㅁㄴㅇㅁ
Tables (9)
admin_board
- id — BIGINT — Primary key — NOT NULL
- type — varchar(20) — NOT NULL
- created_date — timestamp — NOT NULL
- updated_date — timestamp — NOT NULL
- publish_end_date — timestamp
- title — varchar(255) — NOT NULL
- content — varchar — NOT NULL
- attached_file_name — varchar(255)
- attached_file — varchar
- user_id — BIGINT — NOT NULL
book
- id — BIGINT — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- author — varchar(255) — NOT NULL
- isbn — varchar(100) — NOT NULL
- cover — varchar
- publish_date — timestamp — NOT NULL
- sub_title — varchar
- created_date — timestamp — NOT NULL
- updated_date — timestamp — NOT NULL
- summary — varchar
book_item
- id — BIGINT — Primary key — NOT NULL
- book_info_id — BIGINT — NOT NULL
- status — varchar(10) — NOT NULL
- book_code — varchar(20) — NOT NULL
book_reserve
- id — BIGINT — Primary key — NOT NULL
- created_date — timestamp — NOT NULL
- end_date — timestamp — NOT NULL
- status — varchar(10) — NOT NULL — 정상 완료
- book_Id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
book_review
- id — BIGINT — Primary key — NOT NULL
- score — INT — NOT NULL
- content — varchar
- writer — varchar(100) — NOT NULL
- created_date — timestamp — NOT NULL
- update_date — timestamp — NOT NULL
- user_id — BIGINT — NOT NULL
- Key — VARCHAR(255) — NOT NULL
password
- id — BIGINT — Foreign key → user.id
- password — varchar — NOT NULL
rent
- id — BIGINT — Primary key — NOT NULL
- start_date — timestamp — NOT NULL
- end_date — timestamp — NOT NULL
- status — varchar(10) — NOT NULL — 정상 완료 연체
- book_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
user
- id — BIGINT
- email — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- phone — varchar(255) — NOT NULL
user_board
- id — BIGINT — Primary key — NOT NULL
- type — varchar(20) — NOT NULL — 사용자 게시글의 타입 문의 자유글
- created_date — timestamp — NOT NULL
- updated_date — timestamp — NOT NULL
- title — varchar(255) — NOT NULL
- content — varchar — NOT NULL
- attached_file_name — varchar(255)
- attached_file — varchar
- user_id — BIGINT — NOT NULL