nuxt-project
Tables (5)
laon_tbl_activities (활동내역)
- activity_id (Key) — INT — Primary key — NOT NULL
- userid (Field) — VARCHAR(50)
- activity_type (Field2) — VARCHAR(50)
- regdate (Field6) — TIMESTAMP
- board_id (Key2) — INT(11) — Foreign key → laon_tbl_board.board_id — NOT NULL
- comment_id (Key3) — INT — Foreign key → laon_tbl_comments.comment_id — NOT NULL
- like_id (Key4) — INT — Foreign key → laon_tbl_likes.like_id — NOT NULL
laon_tbl_board (게시판)
- board_id (Key) — INT(11) — Primary key — NOT NULL
- userid (Field) — VARCHAR(50)
- writer (Field2) — VARCHAR(50)
- category (Field3) — VARCHAR(50)
- title (Field4) — VARCHAR(200)
- content (Field5) — TEXT
- hitno (Field6) — INT(11)
- like_count (Field7) — INT
- regdate (Field8) — TIMESTAMP
- userid (사용자 ID) — VARCHAR(50) — Foreign key → laon_tbl_user.userid — NOT NULL
laon_tbl_comments (댓글)
- comment_id (Key) — INT — Primary key — NOT NULL
- parent_id (Field2) — INT
- comments_content (Field4) — TEXT
- regdate (Field5) — TIMESTAMP
- updated_at (Field6) — TIMESTAMP
- userid (사용자 ID) — VARCHAR(50) — Foreign key → laon_tbl_user.userid — NOT NULL
- board_id (Key2) — INT(11) — Foreign key → laon_tbl_board.board_id — NOT NULL
laon_tbl_likes (좋아요)
- like_id (Key) — INT — Primary key — NOT NULL
- regdate (Field4) — TIMESTAMP
- userid (사용자 ID) — VARCHAR(50) — Foreign key → laon_tbl_user.userid — NOT NULL
- comment_id (Key2) — INT — Foreign key → laon_tbl_comments.comment_id — NOT NULL
- board_id (Key3) — INT(11) — Foreign key → laon_tbl_board.board_id — NOT NULL
laon_tbl_user (회원)
- userid (사용자 ID) — VARCHAR(50) — Primary key — NOT NULL
- name (이름) — VARCHAR(50)
- password (비밀번호) — VARCHAR(255)
- email (이메일) — VARCHAR(100)
- status (계정 상태) — VARCHAR(20)
- provider (가입 경로) — VARCHAR(20)
- job (직업) — VARCHAR(20)
- hobbies (취미) — VARCHAR(100)
- gender (성별) — VARCHAR(10)
- regdate (가입일) — TIMESTAMP
- updateat (수정일) — TIMESTAMP