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