artinfo

Tables (8)

comment (댓글)

  • id (아이디) — varchar(255) — Primary key — NOT NULL
  • author (작성자) — varchar(255)
  • contents (내용) — text
  • createdAt (생성일) — date
  • user_id (아이디2) — varchar(255) — Foreign key → user.id — NOT NULL
  • notice_board_id (아이디3) — int — Foreign key → notice_board.id — NOT NULL
  • concert_board_id (아이디4) — int — Foreign key → concert_board.id — NOT NULL
  • issue_board_id (아이디5) — int — Foreign key → issue_board.id — NOT NULL
  • education_board_id (아이디6) — int — Foreign key → education_board.id — NOT NULL
  • recruit_board_id (아이디7) — int — Foreign key → recruit_board.id — NOT NULL

concert_board (공연 게시판)

  • id (아이디) — varchar(255) — Primary key — NOT NULL
  • title (제목) — varchar(255)
  • contents (내용) — text
  • count_of_views (조회수) — int
  • location (장소) — varchar(255)
  • date (공연 일) — varchar(255)
  • time (공연 시간) — varchar(255)
  • createdAt (생성일) — date
  • user_id (아이디2) — varchar(255) — Foreign key → user.id — NOT NULL

education_board (교육 게시판)

  • id (아이디) — varchar(255) — Primary key — NOT NULL
  • title (제목) — varchar(255)
  • contents (내용) — text
  • author (글쓴이) — varchar(255)
  • count_of_views (조회수) — int
  • createdAt (생성일) — date
  • user_id (아이디2) — varchar(255) — Foreign key → user.id — NOT NULL

image (이미지)

  • id (아이디) — varchar(255) — Primary key — NOT NULL
  • type (사용처) — varchar(255)
  • url (이미지 주소) — varchar(255)
  • createdAt (생성일) — date
  • status (사용 유무) — tinyint(1)
  • recruit_board_id (채용 게시판 아이디) — varchar(255) — Foreign key → recruit_board.id — NOT NULL
  • education_board_id (교육 게시판 아아디) — varchar(255) — Foreign key → education_board.id — NOT NULL
  • issue_board_id (이슈 게시판 아이디) — varchar(255) — Foreign key → issue_board.id — NOT NULL
  • concert_board_id (연주 게시판 아이디) — varchar(255) — Foreign key → concert_board.id — NOT NULL
  • notice_board_id (아이디6) — varchar(255) — Foreign key → notice_board.id — NOT NULL
  • user_id (아이디7) — varchar(255) — Foreign key → user.id — NOT NULL

issue_board (이슈 게시판)

  • id (아이디) — varchar(255) — Primary key — NOT NULL
  • title (제목) — varchar(255)
  • contents (내용) — text
  • count_of_views (조회수) — int
  • createdAt (생성일) — date
  • user_id (아이디2) — varchar(255) — Foreign key → user.id — NOT NULL

notice_board (공지 게시판)

  • id (아이디) — varchar(255) — Primary key — NOT NULL
  • title (제목) — varchar(255)
  • contents (내용) — text
  • author (글쓴이) — varchar(255)
  • count_of_views (조회수) — int
  • createdAt (생성일) — date
  • user_id (아이디2) — varchar(255) — Foreign key → user.id — NOT NULL

recruit_board (취업 게시판)

  • id (아이디) — varchar(255) — Primary key — NOT NULL
  • title (제목) — varchar(255)
  • contents (내용) — text
  • author (글쓴이) — varchar(255)
  • count_of_views (조회수) — int
  • createdAt (생성일) — date
  • user_id (아이디2) — varchar(255) — Foreign key → user.id — NOT NULL

user (회원)

  • id (아이디) — varchar(255) — Primary key — NOT NULL
  • name (이름) — varchar(255)
  • nick_name (닉네임) — varchar(255)
  • email (이메일) — varchar(255)
  • password (비밀번호) — varchar(255)
  • createdAt (생성일) — date