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