EzenProject
Tables (8)
auth_member (Untitled4)
- auth — VARCHAR(100)
- email — VARCHAR(200) — Foreign key → member.email — NOT NULL
file (Untitled)
- uuid — VARCHAR(256) — Primary key — NOT NULL
- save_dir — VARCHAR(256)
- file_name — VARCHAR(256)
- file_type — INT(1)
- bno — BIGINT
- file_size — BIGINT
- reg_at — DATETIME
member (Untitled3)
- email — VARCHAR(200) — Primary key — NOT NULL
- pwd — VARCHAR(256)
- nick_name — VARCHAR(100)
- reg_at — DATETIME
- last_login — DATETIME
- phone — VARCHAR(50)
qna (Untitled2)
- bno — INT — Primary key — NOT NULL
- 제목 (title) — VARCHAR(200)
- 작성자 (writer) — VARCHAR(200)
- 내용 (content) — TEXT
- 삭제 (isDel) — VARCHAR(10) — NOT NULL
- reg-date (reg_date) — DATETIME
- read_count — INT
- cmt_qty — INT
qnacomment (Untitled5)
- cno — BIGINT — Primary key — NOT NULL
- bno — BIGINT
- writer — VARCHAR(200)
- content — TEXT
- reg_at — DATETIME
- mod_at — DATETIME
reservation (Untitled7)
- reservnum — INT — Primary key — NOT NULL
- rno — INT — Foreign key → room.rno — NOT NULL
- email — VARCHAR(200) — Foreign key → member.email — NOT NULL
- reservedtime — INT
- date — DATETIME
review (CopyOfUntitled2)
- bno — INT — Primary key — NOT NULL
- 제목 (title) — VARCHAR(200)
- 작성자 (writer) — VARCHAR(200)
- 내용 (content) — TEXT
- 삭제 (isDel) — VARCHAR(10) — NOT NULL
- reg-date (reg_date) — DATETIME
- read_count — INT
- cmt_qty — INT
- rno — INT — Foreign key → room.rno — NOT NULL
room (Untitled6)
- rno — INT — Primary key — NOT NULL
- rname — INT
- is_reserved — VARCHAR(10)
- price — INT
- uuid — VARCHAR(256) — Foreign key → file.uuid — NOT NULL