nest-project

Tables (3)

Member (멤버)

  • idx — int(11) — Primary key — NOT NULL
  • member_id (memberId) — varchar(50) — NOT NULL — member id
  • password (user id) — varchar(255) — NOT NULL — member password
  • create_dt (Field3) — timestamp — NOT NULL — create date
  • delete_yn (Field) — varchar(2) — NOT NULL — member delete yn

Member Role (Untitled2)

  • idx — Foreign key → Member.idx — NOT NULL
  • member_id (memberId) — varchar(50) — NOT NULL — member Id
  • member_status (memberStatus) — varchar(20) — NOT NULL — member status

TodoList (투두리스트)

  • board_id (boardId) — int(11) — Primary key — NOT NULL — board id
  • board_title (boardTitle) — varchar(50) — NOT NULL — board title
  • board_content (boardContent) — varchar(255) — NOT NULL — board content
  • create_dt (createDt) — timestamp — NOT NULL — board create date
  • delete_yn (deleteYn) — varchar(2) — NOT NULL — board delete yn
  • update_dt (updateDt) — timestamp — board update date
  • idx (member_idx) — int(11) — Foreign key → Member.idx — NOT NULL — member idx
  • member_id (memberId) — varchar(50) — NOT NULL — member id