eco_car

Tables (6)

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