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