OCEAN

Tables (12)

applications

  • id — bigint — Primary key — NOT NULL
  • no — varchar(20) — NOT NULL — 신청번호
  • uuid — varchar(36) — NOT NULL
  • user_id — varchar(36) — NOT NULL
  • round_no — int — NOT NULL — 회차
  • subject_id — bigint — NOT NULL — 주제
  • status — varchar(255) — 상태
  • title — varchar(512) — 제목
  • description — text — 설명
  • name_enc — varchar(255) — 이름
  • is_lunar — tinyint — NOT NULL — 음력여부
  • birth_enc — varchar(255) — 생년월일
  • gender — enum('male', 'female') — 성별
  • zip_code — varchar(255) — 우편번호
  • address_enc — text — 주소
  • address_detail_enc — text — 상세주소
  • parent_name_enc — varchar(255) — 부모님 성함
  • parent_phone_enc — varchar(255) — 부모님 전화번호
  • school_name — varchar(255) — 학교명
  • school_area — varchar(255) — 소재지
  • school_address — text — 학교 주소
  • level — varchar(255) — 분야
  • grade — varchar(255) — 학년
  • class — varchar(255) — 반
  • created_at — timestamp
  • updated_at — timestamp

articles

  • id — bigint — Primary key — NOT NULL
  • article_id — varchar(255)
  • title — text — NOT NULL
  • json — text
  • created_at — timestamp
  • updated_at — timestamp

attachments

  • id — bigint — Primary key — NOT NULL
  • attachable_id — bigint — NOT NULL — 연결된 모델 PK
  • attachable_type — varchar(255) — NOT NULL — 연결된 모델 타입
  • collection_name — varchar(255) — NOT NULL — 배너/포스터/기본
  • file_name — varchar(255) — NOT NULL — 실제 파일명
  • file_path — varchar(255) — NOT NULL — 저장 경로/URL
  • thumbnail_path — varchar(255) — 썸네일 이미지 경로
  • file_size — bigint — NOT NULL — 파일 크기
  • width — int — 너비
  • height — int — 높이
  • file_ext — varchar(255) — 파일 확장자/타입
  • created_at — timestamp
  • updated_at — timestamp

banners

  • id — bigint — Primary key — NOT NULL
  • is_active — tinyint — NOT NULL — 활성화 여부
  • title — varchar(510) — NOT NULL — 배너 제목
  • image_url — varchar(510) — NOT NULL — 배너 이미지 URL
  • link_url — varchar(510) — 배너 링크 URL
  • target — varchar(255) — NOT NULL — 연결 대상 (_self, _blank)
  • path — varchar(255) — NOT NULL — 파일 경로
  • filename — varchar(255) — NOT NULL — 파일명
  • ext — varchar(255) — NOT NULL — 확장자
  • seq — int — NOT NULL — 배너 순서
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

levels

  • id — bigint — Primary key — NOT NULL
  • key — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

notices

  • id — bigint — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL — 공지 제목
  • content — text — NOT NULL — 본문 텍스트
  • is_active — tinyint(1) — NOT NULL — 표출여부
  • published_at — timestamp — NOT NULL — 등록일자
  • deleted_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp

past_contests

  • id — bigint — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • user_id — bigint — NOT NULL
  • deleted_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp

rounds

  • id — bigint — Primary key — NOT NULL
  • year — varchar(255) — NOT NULL — 연도
  • round_no — int — NOT NULL — 회차 번호
  • published_at — timestamp — NOT NULL — 공개 일정
  • entry_start_date — timestamp — 작품 접수 시작일
  • entry_end_date — timestamp — 작품 접수 종료일
  • winner_announce_date — timestamp — 수상자 발표일
  • award_date — timestamp — 시상식 일정
  • award_place — varchar(255) — 시상식 장소
  • exhibit_start_date — timestamp — 전시 시작일
  • exhibit_end_date — timestamp — 전시 종료일
  • exhibit_place — varchar(255) — 전시 장소
  • is_active — tinyint(1) — NOT NULL — 활성화 여부
  • created_at — timestamp
  • updated_at — timestamp

sponsors

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • logo — varchar(512)
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

subjects

  • id — bigint — Primary key — NOT NULL
  • round_id — bigint — 회차 ID
  • title — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

user_logs

  • id — bigint — Primary key — NOT NULL
  • action — varchar(50) — NOT NULL
  • user_id — varchar(36) — NOT NULL
  • ip_address — varchar(50)
  • user_agent — text
  • created_at — timestamp — NOT NULL

users

  • id — bigint — Primary key — NOT NULL
  • uuid — varchar(36) — NOT NULL
  • nickname — varchar(255)
  • token — varchar(255)
  • last_login_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp