story-of-arda-renewal

Tables (10)

character (인물)

  • character_id (캐릭터 id) — PRIMARY KEY — Primary key — NOT NULL
  • page_id (페이지 id) — PRIMARY KEY — Foreign key → page.page_id — NOT NULL
  • birth_date (출생연도) — CAN NULL
  • death_date (사망연도) — CAN NULL
  • region_id (지역 id) — PRIMARY KEY — Foreign key → region.region_id — NOT NULL

image (이미지)

  • image_id (이미지 id) — PRIMARY KEY — Primary key — NOT NULL
  • url (이미지 url) — NOT NULL

line (geo라인)

  • line_id (라인 id) — PRIMARY KEY — Primary key — NOT NULL
  • start_point (시작 좌표) — NOT NULL
  • ene_point (끝 좌표) — NOT NULL
  • region_id (지역 id) — PRIMARY KEY — Foreign key → region.region_id — NOT NULL

map (지도)

  • map_id (지도 id) — PRIMARY KEY — Primary key — NOT NULL
  • name (지도 이름) — NOT NULL
  • image_id (이미지 id) — PRIMARY KEY — Foreign key → image.image_id — NOT NULL

nickname (이명)

  • character_id (캐릭터 id) — PRIMARY KEY — Foreign key → character.character_id — NOT NULL
  • nickname (이명) — NOT NULL

page (페이지)

  • page_id (페이지 id) — PRIMARY KEY — Primary key — NOT NULL
  • name (이름) — NOT NULL
  • counter (조회수) — NOT NULL

page_image (페이지-이미지)

  • page_id — PRIMARY KEY — Foreign key → page.page_id — NOT NULL
  • image_id (이미지 id) — PRIMARY KEY — Foreign key → image.image_id — NOT NULL

region (지역)

  • region_id (지역 id) — PRIMARY KEY — Primary key — NOT NULL
  • page_id — PRIMARY KEY — Foreign key → page.page_id — NOT NULL
  • brief_description (간략 설명) — NOT NULL
  • Field
  • map_id (지도 id) — PRIMARY KEY — Foreign key → map.map_id — NOT NULL

text (텍스트)

  • page_id (페이지 id2) — PRIMARY KEY — Foreign key → page.page_id — NOT NULL
  • text (페이지 내용) — NOT NULL
  • h_one (h1태그 갯수) — NOT NULL

tree (가계도)

  • Key — Primary key — NOT NULL
  • character_id (캐릭터 id) — PRIMARY KEY — Foreign key → character.character_id — NOT NULL
  • Field