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