3
Tables (7)
CHARACTER
- character_name — VARCHAR(100) — Primary key — NOT NULL
- world_icon_id — INT — Foreign key → WORLD.world_icon_id — NOT NULL
- nexon_id — VARCHAR(100) — Foreign key → NEXON_USER.nexon_id
- character_url — VARCHAR(500) — NOT NULL
COMMENT
- comment_sn — INT — Primary key — NOT NULL
- event_id — INT — Foreign key → EVENT.event_id — NOT NULL
- character_name — VARCHAR(100) — Foreign key → CHARACTER.character_name — NOT NULL
- comment_text — TEXT — NOT NULL
- comment_date — DATE — NOT NULL
EVENT
- event_id — INT — Primary key — NOT NULL
- title — VARCHAR(200) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
- view_count — INT — NOT NULL
- board_url — VARCHAR(300)
- thumbnail_url — VARCHAR(300)
EVENT_BANNER
- banner_id — INT — Primary key — NOT NULL
- event_id — INT — Foreign key → EVENT.event_id — NOT NULL
- banner_image_url — VARCHAR(300) — NOT NULL
- data_title — VARCHAR(200)
NEXON_USER
- nexon_id — VARCHAR(100) — Primary key — NOT NULL
- maple_id — VARCHAR(100)
- is_login — TINYINT(1) — NOT NULL
- is_membership — TINYINT(1) — NOT NULL
WORLD
- world_icon_id — INT — Primary key — NOT NULL
- world_name — VARCHAR(50) — NOT NULL
- icon_url — VARCHAR(300) — NOT NULL
user (Untitled)
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- Field