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